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

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

A. tracking the most recent read time for a table segment in a user tablespace

B. tracking the most recent write time for a table segment in a user tablespace

C. tracking insert time by row for table rows

D. tracking the most recent write time for each block in a table segment

E. tracking the most recent read time for a table segment in the sysauxtablespace

F. tracking the most recent write time for a table segment in the sysauxtablespace

For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.

You execute the command: RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;

Which statement is true about the execution of the command?

A. It returns an error because there is no level 0 backup available for new data files.

B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.

C. It performs a level-0 backup of all data files including those that belong to the new tablespace.

D. It performs an image copy backup of all data files including those that belong to the new tablespace.

E. It performs a backup as a backup set of all data files including those that belong to the new tablespace.

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.

Which two statements are true?

A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.

B. All database listeners running from the database home are automatically added to the Oracle Restart configuration.

C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.

D. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.

E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Which three statements are true about unplugging a pluggable database (PDB)?

A. The PDB must be open in read only mode.

B. The PDB must be dosed.

C. The unplugged PDB becomes a non-CDB.

D. The unplugged PDB can be plugged into the same multitenant container database (CDB)

E. The unplugged PDB can be plugged into another CDB.

F. The PDB data files are automatically removed from disk.

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

B. In a PDB plan, subplans may be used with up to eight consumer groups.

C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR

schema.

After a few days, you want to alter the EMPLOYEES table by executing the command:

SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);

Which statement is true about the execution of the command?

A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.

B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

C. It executes successfully and continues to store metadata related to the EMPLOYEES table.

D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

You create a new database by using the CREATE DATABASE command in SQL*Plus, with the ENABLE PLUGGABLE DATABASE clause specified.

Which statement is true about the database that is created? (Choose the best answer.)

A. It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.

B. It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).

C. It is created as a PDB that must be plugged into an existing CDB.

D. It is created as a CDB with the CDB$ROOT and PDB$SEED databases.

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. Two channels are allocated and two copies of the backup set are taken in parallel in both locations

B. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations

C. The default channel is allocated and the backup set is created in only one destination

D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2

You are installing Oracle Database 12c with the Oracle Universal Installer (OUI). You select the option to create a database by using file system storage but you do not explicitly set ORACLE_BASE. What is the effect on the installation?

A. The installation proceeds with the default value but a message is generated in the alert log file

B. The installation terminates with an error

C. The installation proceeds with the default value but the database creation is not attempted

D. The software installation proceeds with the default value but database creation fails