ocp-003

最新推荐文章于 2024-09-26 21:04:50 发布

佳岳

最新推荐文章于 2024-09-26 21:04:50 发布

阅读量868

点赞数

分类专栏： OCP-1Z0-053 文章标签： plsql sql it oracle-ocp ocp

OCP-1Z0-053 专栏收录该内容

674 篇文章 0 订阅

订阅专栏

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.

PL-SQL块
BEGIN
dbms_spm.configure(‘SPACE_BUDGET_PERCENT’, 30);
END;
有关上述PL / SQL块哪种说法是正确的
D. 当SQL管理库占了30％以上的系统辅助表空间时，它会在警报日志文件中产生一个每周预警。