You are connected to a recovery catalog and target database. You execute the command:
RMAN> CATALOG START WITH '/disk1/backups';
Which statement is true?

• A. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.
• B. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.
• C. It lists all the data file copies, backup pieces, and archived logs cataloged in the recovery catalog in the
  /disk1/backups directory and its subdirectories.
• D. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.

RMAN is configured to create backupset backups for your database. You issue the command to back up the database:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command? (Choose two.)

• A. Only the used blocks in the data files are backed up
• B. It backs up all the archived log files and deletes the ones that were just backed up
• C. It backs up all the data files and deletes obsolete backups after the backup is complete
• D. It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete
• E. It backs up only those archived log files that are not backed up at least once

You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT "/disk/%U';
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT "/disk/%U';
RMAN> BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUP command?

• A. The default channel is allocated and the backup set is created in only one destination
• B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations
• C. Two channels are allocated and two copies of the backup set are taken in parallel in both locations
• D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2

You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1.Restore an autobackup of the server parameter file.
2.Restore the control file.
3. Start up the database instance in nomount state.
4.Mount the database.
5.Restore the data files.
6.Open the database with the resetlogs option.
7.Recover the data files.
8.Set DBID for the database.
Identify the required steps in the correct order.

• A. 1, 8, 3, 2, 4, 5, 7, 6
• B. 1, 3, 2, 4, 8, 5, 6, 7
• C. 8, 1, 3, 2, 4, 5, 7, 6
• D. 8, 1, 3, 2, 4, 5, 6
• E. 8, 3, 2, 4, 5, 7, 6

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 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 visible by default when the table is described.
• D. The valid time columns are not populated by the Oracle Server automatically.
• E. The valid time columns employee_time_start and employee_time_end are automatically created.