Question 16
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.Set the 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.Set the 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 17
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1.Create directory structures similar to the production database on all new machines.
2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3.Create a database clone template for the database.
4.Run the Database Configuration Assistant (DBCA) to create the database.
5.Run OUI in graphical mode on each machine.
6.Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1.Create directory structures similar to the production database on all new machines.
2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3.Create a database clone template for the database.
4.Run the Database Configuration Assistant (DBCA) to create the database.
5.Run OUI in graphical mode on each machine.
6.Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.
Question 18
Which three statements are true about a job chain?
Question 19
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when
it is enabled? (Choose two.)
it is enabled? (Choose two.)
Question 20
You restore and recover your database to a new host by using an existing RMAN open database backup.
Which step must you perform next?
Which step must you perform next?