Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

A. when the duplicate ... from active database command contains the section size clause

B. when you perform active database duplication on a database with flashback disabled

C. when you specify set encryption before the duplicate ... from active database command

D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

E. when you perform active database duplication on a database that has read-only tablespaces

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.

The statistics_level parameter is PDB modifiable.

As the user sys, execute the following command on pdb2:

SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;

Which statement is true about the result of this command?

A. The statistics_level parameter is set to all when any of the PDBs is reopened.

B. The statistics_level parameter is set to all only for PDB2 when it is reopened.

C. The statistics_level parameter is set to all when the root database is restarted.

D. The statement is ignored because there is no SPFILE for a PDB.

Examine the command and its output:

SQL> DROP TABLE EMPLOYEE;

SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;

RECYCLE_NAMEORIGINAL_NAMETYPE

binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE

You then successfully execute the command:

SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;

Which two statements are true?

A. It flashes back the employee table and all the constraints associated with the table.

B. It automatically flashes back all the indexes on the employes table.

C. It automatically flashes back any triggers defined on the table.

D. It flashes back only the structure of the table and not the data.

E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rc12c user.

The CATDB11 database contains an Oracle Database 11g catalog schema owned by the rc11 user.

A database with dbid=1423241 is registered in the catdb11

catalog. Both the recovery catalog databases are open.

In the CATDB12c database, you execute the commands:

$rman

RKAN> CONNECT CATALOG rc12c/pass12c@catdb12c

RKAN> IMPORT CATALOG rc11/pwdcat11@catdb11 DBID=1423241;

What is the outcome of the import?

A. It fails because the target database and recovery catalog database are of different versions.

B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.

C. It succeeds but the database is not automatically registered in the RC12C catalog.

D. It fails because RMAN is not connected to the target database with DBID=1423241

You execute the command to recover your database.

Which statement is true?

A. It restores all data files from the specified time, and then applies the redo logs

B. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time

C. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archieve logs that are needed to complete the task

D. It restores the control file and all data files from the most recent backup, and then applies the redo logs up to the "until time".