The following parameter 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_EVOLVE_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:

• A.2, 4, 5
• B.2, 1, 4, 3, 5
• C.1, 2, 3, 4, 5
• D.1, 2, 4, 5

Correct Answer: B

Explanation/Reference:
Explanation:
* Evolving SQL Plan Baselines

* 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
This function creates an advisor task to prepare the plan evolution of one or more plans for a specified SQL statement. The input parameters can be a SQL handle, plan name or a list of plan names, time limit, task name, and description.
1. Set the evolve task parameters.
SET_EVOLVE_TASK_PARAMETER
This function updates the value of an evolve task parameter. In this release, the only valid parameter is TIME_LIMIT.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
This function executes an evolution task. The input parameters can be the task name, execution name, and execution description. If not specified, the advisor generates the name, which is returned by the function.
3: IMPLEMENT_EVOLVE_TASK
This function implements all recommendations for an evolve task. Essentially, this function is equivalent to using ACCEPT_SQL_PLAN_BASELINE for all recommended plans. Input parameters include task name, plan name, owner name, and execution name.
5. Report the task outcome by using the DBMS_SPM_EVOLVE_TASK function.
This function displays the results of an evolve task as a CLOB. Input parameters include the task name and section of the report to include.
References:

Comment: *

Name: *

Email: *

Verification: *

Examine the query and its output executed In an RDBMS Instance:

Which three statements are true about the users (other than sys) in the output?

• A.The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
• B.The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
• C.The C # # A_ADMIN user can perform wallet operations.
• D.The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
• E.The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

Comment: *

Name: *

Email: *

Verification: *

Your database is running in ARCHIVELOG mode.
You want to take a consistent whole database backup.
Which two statements are true in this scenario? (Choose two.)

• A.RMAN backups contain only data files.
• B.Consistent RMAN backups can be taken while the database is open.
• C.The database instance must be shut down to take a user-managed consistent backup.
• D.User-managed backups only contain formatted data blocks.
• E.The database must be in MOUNT state to take consistent RMAN backups.

Comment: *

Name: *

Email: *

Verification: *

In your database, the STATISTICS_LEVELparameter is set to TYPICALand an Automatic
Workload Repository (AWR) snapshot is taken every 30 minutes.
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

• A.It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
• B.It always compares the latest snapshot with the baseline snapshot for analysis.
• C.It calls other advisors if required, but does not provide recommendations about the advisors to be used.
• D.It requires at least four AWR snapshots for analysis.
• E.It measures database performance by analyzing the wait time and CPU time of all non-idle user
  sessions.

Comment: *

Name: *

Email: *

Verification: *

You executed the following query:

Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

• A.The system change number (SCN) and the time when the Flashback Database was enabled in the database instance
• B.The time when the last flashback operation in your database was performed
• C.The approximate time and the lowest system change number (SCN) to which you can flash back your database
• D.The time when the first flashback operation in our database was performed

Comment: *

Name: *

Email: *

Verification: *