Oracle Database 12c: Advanced Administration — Question 80

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

Option A is correct because setting the statistics level to ALL with SCOPE=BOTH updates both the memory and the SPFILE. Option B is also correct as it applies to PDBs with a typical setting. The other options are incorrect as they either misstate the scope of the change or imply limited applicability that does not align with the command executed.