OCP 1Z0 053 103

103.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 SYSAUX tablespace for SQL Management Base (SMB). 
C. It reserves 30% of the space in the SYSTEM tablespace for SMB.  
D. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX 
tablespace. 
Answer: D 


SQL management base (SMB)
http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_spm.htm#ARPLS68161

Table 136-6 Names & Values for CONFIGURE Procedure Parameters

Name	Description	Possible Values	Default Value
space_budget_percent	Maximum percent of SYSAUX space that can be used for SQL management base	1,2, …, 50	10
plan_retention_weeks	Number of weeks to retain unused plans before they are purged	5,6, …, 523	53