Prev Question
Next Question

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 true about the result of this command?

A.
The STATISTICS_LEVEL parameter is set to all 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.

Explanation:
Note:
* In a container architecture, the parameters for PDB will inherit from the root database. That means if
statistics_level=all in the root that will cascade to the PDB databases.
You can override this by using Alter system set, if that parameter is pdb modifiable, there is a new column in
v$system_parameter for the same.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *