103.Observe the following PL/SQL block: BEGIN dbms_spm.configure

分类: 英语题型 发布时间: 2023-12-01 12:13 浏览量: 0

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.

正确答案是D