Q1. 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:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A. The valid time columns employee_time_start and employee_time_end are automatically created. 

B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.

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. 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.

View Answer

Q2. Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

A. Maximum Undo per consumer group

B. Maximum Idle time

C. Parallel server limit

D. CPU

E. Exadata I/O

F. Local file system I/O

View Answer

Q3. To enable the Database Smart Flash Cache, you configure the following parameters:

DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ 

DB_FLASH_CACHE_SIZE=64G

What is the result when you start up the database instance?

A. It results in an error because these parameter settings are invalid. 

B. One 64G flash cache file will be used. 

C. Two 64G flash cache files will be used. 

D. Two 32G flash cache files will be used. 

View Answer

Q4. Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.

The table does not have a primary key and is used by an OLTP application.

Which technique will move the table and indexes while maintaining the highest level of availability to the application?

A. Oracle Data Pump.

B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.

C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.

D. Online Table Redefinition.

E. Edition-Based Table Redefinition.

View Answer

Q5. Which three statements are true about SQL plan directives?

A. They are tied to a specific statement or SQL ID. 

B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.

C. They are used to gather only missing statistics.

D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.

E. They instruct the optimizer to create only column group statistics.

F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

View Answer

Q6. Which two statements are true about the Oracle Direct Network File system (DNFS)?

A. It utilizes the OS file system cache.

B. A traditional NFS mount is not required when using Direct NFS.

C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.

D. Direct NFS is available only in UNIX platforms.

E. Direct NFS can load-balance I/O traffic across multiple network adapters.

View Answer

Q7. Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.

The steps to recover the tablespace are as follows:

1.Mount the CDB. 

2.Close all the PDBs.

3.Open the database.

4.Apply the archive redo logs.

5.Restore the data file.

6.Take the SYSAUX tablespace offline.

7.Place the SYSAUX tablespace online.

8.Open all the PDBs with RESETLOGS.

9.Open the database with RESETLOGS.

10.Execute the command SHUTDOWN ABORT.

Which option identifies the correct sequence to recover the SYSAUX tablespace?

A. 6, 5, 4, 7

B. 10, 1, 2, 5, 8

C. 10, 1, 2, 5, 4, 9, 8

D. 10, 1, 5, 8, 10

View Answer

Q8. Which two statements are true about Oracle Managed Files (OMF)?

A. OMF cannot be used in a database that already has data files created with user- specified directions.

B. The file system directions that are specified by OMF parameters are created automatically.

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

D. OMF automatically creates unique file names for table spaces and control files.

E. OMF may affect the location of the redo log files and archived log files.

View Answer

Q9. 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

View Answer

Q10. Which three statements are true about Oracle Data Pump export and import operations?

A. You can detach from a data pump export job and reattach later.

B. Data pump uses parallel execution server processes to implement parallel import.

C. Data pump import requires the import file to be in a directory owned by the oracle owner.

D. The master table is the last object to be exported by the data pump.

E. You can detach from a data pump import job and reattach later.

View Answer