Which statement is correct regarding the above PL/SQL block?

Observe the following PL/SQL block: BEGIN
dbms_spm.configure(‘SPACE_BUDGET_PERCENT’, 30); END; Which statement is correct
regarding the above PL/SQL block?

Observe the following PL/SQL block: BEGIN
dbms_spm.configure(‘SPACE_BUDGET_PERCENT’, 30); END; Which statement is correct
regarding the above PL/SQL block?

A.
It automatically purges the SQL management objects when SMB occupies more than
30% of the SYSAUX tablespace.

B.
It reserves 30% of the space in the SYSTEM tablespace for SMB.

C.
It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base
(SMB).

D.
It generates a weekly warning in the alert log file when SMB occupies more than 30% of
the SYSAUX tablespace.



Leave a Reply 0

Your email address will not be published. Required fields are marked *