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 reserves 30% of the space in the SYSTEM tablespace for SMB.
B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).
C. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.
D. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.
|
Download Printable PDF. VALID exam to help you PASS. |
 |