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:
Note:
* In a container architecture, the parameters for PDB will inherit from the root database. That
means if statistics_level=all in the root that will cascade to the PDB databases.
You can over ride this by using Alter system set, if that parameter is pdb modifiable, there is a new
column in v$system_parameter for the same.
I tried this scenario correct Answer is A
Yes,test SAYED you are right!
Correct Answer is A, I have also tested it
The given answer, C is wrong because it is not the only true statement. Changing a parameter and specifying SCOPE=SPFILE means that change will not take effect until the instance/database is re-started. If the CDB is re-started then that will close and MOUNT all the PDBs. When the PDB in question is re-opened, its STATISTICS_LEVEL will have changed. So C is a true statement. However, closing and re-opening the PDB in question will have the same effect, i.e. when it re-opens its STATISTICS_LEVEL will have changed. So A is also true. Hence, C is not the only true statement.
H*T*H
agree with H*T*H, correct answers are A,C
rf. http://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN14018
A,C are right.
A cause Parameters are when PDB is closed.
C because spfile will do its job
R= A
SQL> ALTER SESSION SET CONTAINER = db12cp;
Session altered.
SQL> ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;
System altered.
SQL> show parameters STATISTICS_LEVEL
NAME TYPE VALUE
———————————— ———– ——————————
statistics_level string TYPICAL
SQL> startup force
Pluggable Database opened.
SQL> show parameters STATISTICS_LEVEL
NAME TYPE VALUE
———————————— ———– ——————————
statistics_level string ALL
SQL> sho con_id
CON_ID
——————————
3
SQL> select con_id,name,open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
———- —————————— ———-
3 DB12CP READ WRITE
Hello there, You have done an incredible job. I will definitely digg it and personally suggest to my friends. I’m confident they’ll be benefited from this site.|
Correct answer is A.
A