Oracle Database 12c Advance Adminstration1z0-063 Test 4

Question : 14 of 40

Marks: +1, -0

One of your multitenant container databases (CDB) contains two pluggable databases (PDBs) called PDB1 and PDB2.
You connect to PDB2 as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB modifiable.
As the user SYS, you execute this command successfully on PDB2:
SQL> ALTER SET STATISTICS_LEVEL=ALL SID=’*’ SCOPE=BOTH;Which two statements are true about the result of this command?

The data dictionary in PDB2 is updated.
The STATISTICS_LEVEL parameter is set to ALL in memory only for PDB2.
The SPFILE is updated.
The data dictionary in CDB $\$$ ROOT is updated.
The STATISTICS_LEVEL parameter is set to ALL in memory for both PDBs.

Validate

Go to Question:

Prev Question

Next Question