Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP: 1Z0-067

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 fails because archive log files cannot be backed up using a connection to a PDB.

B. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.

C. It succeeds and all data files belonging to PD2_i are backed up along with the archive log files.

D. It fails because the pluggable clause is missing.

Examine the backup requirement for your company:

1) Every Sunday, a backup of all used data file blocks is performed.

2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is

performed.

3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.

Which backup strategy satisfies the requirements?

A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days

C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days

D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

Before a Flashback Table operation, you execute the following command:

ALTER TABLE employees ENABLE ROW MOVEMENT;

Why would you need this to be executed?

A. Because row IDs may change during the flashback operation

B. Because the object number changes after the flashback operation

C. Because the rows are retrieved from the recycle bin during the flashback operation

D. Because the table is moved forward and back to a temporary during the flashback operation