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