Upgrade Oracle DBA 11g to Oracle Database 12c — Question 18

Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the statistics level parameter?

Answer options

• A. It is immediately set to all in the SPFILE and the CDB instance.
• B. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
• C. It is immediately set to all only for cd3Sroot.
• D. It is immediately set to all in all PDBs where the statistics_level parameter is not set.
• E. It is set to all for all PDBs only in the SPFILE.

Correct answer: A, B

Explanation

The correct answer A is true because setting the statistics level to ALL affects both the current instance and the SPFILE. Answer B is also correct as it applies to PDBs where the statistics_level is set to typical. The other options are incorrect because they either misstate the scope of the change or the conditions under which it applies.