Online Access Free 1z0-063 Practice Test

Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2. RMAN is connected to the target database PDB2_1.
Examine the command executed to back up PDB2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?

• A.It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.
• B.It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.
• C.It fails because archive log files cannot be backed up using a connection to a PDB.
• D.It fails because the PLUGGABLE clause is missing.

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENTION 2 YEAR;
What is the outcome?

• A.All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years.
• B.All historical data older than two years, if any, is purged from the flashback archive FDA1.
• C.All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.
• D.An error is returned because the retention period cannot be reduced.

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

• A.Reduced physical I/O
• B.Reduced virtual memory utilization
• C.Reduced CPU utilization
• D.Reduced logical I/O
• E.Improved Serial Execution performance

Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:

Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?

• A.It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.
• B.It is set to TRUE for the root database and the pluggable database PDB2, because values can be set for this parameter at the PDB level in a PDB.
• C.It gives an error because it cannot be set for the root database.
• D.It is set to TRUE for the root database and all the PDBs, but is effective only when the CDB is restarted and the PDBs are reopened.

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? (Choose three.)

• A.The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• B.The valid time columns are not populated by the Oracle Server automatically.
• C.The valid time columns are visible by default when the table is described.
• D.The valid time columns employee_time_start and employee_time_end are automatically created.
• 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.