You are connected to a multitenant container database (CDB) with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
What three effects does this have on the CDB AND IT'S PLUGGABLE DATABASE (PDBs)?
A. The STATISTICS_LEVEL parameter is immediately set to ALL in all PDBs.
B. The STATISTICS_LEVEL parameter is set to ALL in the SPFILE.
C. The STATISTICS_LEVEL parameter is immediately set to ALL in the CDB instance.
D. The STATISTICS_LEVEL parameter is set to ALL on all PDBSs when they are opened.
E. The STATISTICS_LEVEL parameter is immediately set to ALL in all PDBs where the STATISTICS_LEVEL parameter has no value set.
Correct Answer:
BCE
The following settings are possible:
-- CURRENT,
the default, means that the parameter setting applies only to the current container.
When the current container is the root, the parameter setting applies to the root and to any PDB with an inheritance property of true for the parameter.
-- ALL,
means that the parameter setting applies to all containers in the CDB, including the root and all of the PDBs.
Specifying ALL sets the inheritance property to true for the parameter in all PDBs.