Oracle
1Z0-067 · Question #206
1Z0-067 Question #206: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #206. The question stem and answer options stay visible for context.
Question
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.)
Options
- AIt gives an error because it cannot be set for the root database.
- BIt is set to TRUE for the root database and the pluggable database PDB2, because values can be
- CIt is set to TRUE for the root database and all the PDBs, because the value set at the root level
- DIt is set to TRUE for the root database and all the PDBs, but is effective only when CDB is
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.