Which is true about the result of this command?

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?

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:
http://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN14017



Leave a Reply 0

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