You are connected to a pluggable database (PDB) as a common user with DBA privileges.<br /> The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:<br /> SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;<br /> Which is true about the result of this command?()<p> You are connected to a pluggable database (PDB) as a common user with DBA privileges.<br /> The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:<br /> SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;<br /> Which is true about the result of this command?()</p>
A、A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
B、B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
C、C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
D、D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.