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.

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

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

• A. The owner of VPC cannot own recovery catalog.
• B. The register database privilege should be granted to the virtual catalog owner.
• C. At least one target database should be registered in the recovery catalog.
• D. The recovery_catalog_owner role should be granted to the virtual catalog owner.
• E. A base recovery catalog should exist.

You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle
12c database:
CONNECT/AS SYSDBA
ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE;
SHUTDOWNIMMEDIATE
You then restart the instance and get an error:
STARTUP
ORA-01031:insufficientprivileges
Why does the startup command return the error shown?

• A. because the threaded architecture requires exiting from sql*pIus and reconnecting with sql*PIus / as sysdba before issuing a startup command
• B. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command
• C. because the threaded architecture requires authentication using a password file before issuing a startup command
• D. because the threaded architecture requires restarting the listener before issuing a startup command
• E. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command

Examine these parameter values:

There are currently no user defined tablespaces with an 8K or 16K blocksize.
Which statement would return an error?

• A. ALTER SYSTEM SET DB_16K_CACHE_SIZE=0;
• B. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
• C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
• D. ALTER SYSTEM SET DB_CACHE_SIZE=50M;
• E. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;

You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
create table employees
(empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

• A. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
• B. The valid time columns employee_time_start and employee_time_end are automatically created.
• C. The valid time columns are not populated by the Oracle Server automatically.
• D. The valid time columns are visible by default when the table is described.
• E. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.