Which two are prerequisites for performing a flashback transaction? (Choose two.)

• A.Flashback Database must be enabled.
• B.Undo retention guarantee for the database must be configured.
• C.EXECUTEprivilege on the DBMS_FLASHBACKpackage must be granted to the user flashing back transaction.
• D.Supplemental logging must be enabled.
• E.Recycle bin must be enabled for the database.
• F.Block change tracking must be enabled for the database.

Comment: *

Name: *

Email: *

Verification: *

In your Oracle 12c database, you create two roles: AUDITORand AUDIT_ADMIN. You then execute the following commands:

To create a privilege analysis policy for the AUDIT_ADMINrole, you execute the following PL/SQLblock:

Which statement is correct about the procedure?

• A.It always captures the use of the CREATE VIEW and CREATE TABLE privileges.
• B.It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT PAYABLE module is used.
• C.It always captures the use of the privileges exercised through the AUDITORand AUDIT_ADMIN roles.
• D.It captures the use of the privileges used through the AUDIT_ADMIN and AUDITORroles when the ACCOUNT PAYABLEmodule is used.

Comment: *

Name: *

Email: *

Verification: *

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

* 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.
Reference: Oracle Database SQL Tuning Guide 12c, Managing SQL Plan Baselines

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about using flashback database in a multitenant container database (CDB)?
(Choose three.)

• A.A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
• B.To enable flashback database, the CDB must be mounted.
• C.The root container can be flashed back without flashing back the pluggable databases (PDBs).
• D.Individual PDBs can be flashed back without flashing back the entire CDB.
• E.The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

Comment: *

Name: *

Email: *

Verification: *

Examine the following command:
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

• A.Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
• B.All DDL commands are logged in the alert log file.
• C.All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
• D.Only DDL commands that resulted in the creation of new segments are logged.
• E.All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Comment: *

Name: *

Email: *

Verification: *