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博客 ” ,链接:http://blog.itpub.net/29047826/viewspace-1672382/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29047826/viewspace-1672382/