Question 136
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?
Question 137
You are connected to a recovery catalog and target database. You execute the command:
RMAN> CATALOG START WITH '/disk1/backups';
Which statement is true?
RMAN> CATALOG START WITH '/disk1/backups';
Which statement is true?
Question 138
In which two locations does the USER_DATA TABLESPACE clause create a tablespace?
Question 139
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1.Setthe evolve task parameters.
2.Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3.Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps.
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1.Setthe evolve task parameters.
2.Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.
3.Implement the recommendations in the task by using the
DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps.
Question 140
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

Which statement is true about the execution of the last command?

Which statement is true about the execution of the last command?