You are connected to a pluggable database (PDB) as a common user with DBA privileges.

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?

Question:

You are connected to a pluggable database (PDB) as a common user with DBA privileges.

Options:

The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.

The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.

Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

Correct Answer

The Correct Answer for this Question is

The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.