Oracle Database 12c: Advanced Administration — Question 133

One of your multitenant container databases (CDB) contains two pluggable databases (PDBs) called PDB1 and PDB2.
You connect to PDB2 as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB modifiable.
As the user SYS, you execute this command successfully on PDB2:
SQL> ALTER SET STATISTICS_LEVEL=ALL SID='*' SCOPE=BOTH;
Which two statements are true about the result of this command?

Answer options

• A. The data dictionary in PDB2 is updated.
• B. The STATISTICS_LEVEL parameter is set to ALL in memory only for PDB2.
• C. The SPFILE is updated.
• D. The data dictionary in CDB$ROOT is updated.
• E. The STATISTICS_LEVEL parameter is set to ALL in memory for both PDBs.

Correct answer:

Explanation

The correct answers are A and B. The command updates the data dictionary in PDB2, reflecting the change in the STATISTICS_LEVEL parameter. However, this change is only applied in memory for PDB2 and does not affect the SPFILE or the CDB$ROOT data dictionary.