Oracle Exam 1Z0-067 Topic 5 Question 35 Discussion

Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.

Examine the commands to change the value of the PDB modifiable initialization parameter:

$> sqlplus sys/oracle_4U@pdb1 AS SYSDBA

SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH;

SQL> CONN sys/oracle_4U@pdb2 AS SYSDBA

SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;

SQL> CONN sys/oracle_4U@pdb1 AS SYSDBA

SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=TRUE SCOPE=BOTH;

Which statement is true about the OPTIMIZER_USER_SQL_PLAN_BASELINES parameter? (Choose the best answer.)