You are connected to a pluggable database(PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID='*' SCOPE=SPFILE;
Which is ture about the result of this command?
A. The STATISTICS_LEVEL parameter is set toall whenever this PDB is re-opened.
B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database(CDB) is restarted.
D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
答案：C
该题是在考英语单词whenever的用法，此处翻译为：只要
只要CDB重新启动，STATISTICS_LEVEL参数就会被设置为all。
SQL> ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID='*' SCOPE=SPFILE;
Which is ture about the result of this command?
A. The STATISTICS_LEVEL parameter is set toall whenever this PDB is re-opened.
B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database(CDB) is restarted.
D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
答案：C
该题是在考英语单词whenever的用法，此处翻译为：只要
只要CDB重新启动，STATISTICS_LEVEL参数就会被设置为all。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29047826/viewspace-1672382/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
12c OCP QUESTION 143
下一篇：
12c CDB的ADG初体验
请登录后发表评论
登录
全部评论
