While performing a cross-platform PDB transport in an Oracle Database 12c Release 2 database, by using XTTS from a Linux (x86-64) server to a Solaris (x86-64) server, this command is executed to back up the files in a compatible format:

What will be the outcome?

A. It creates the /tmp/pdb_orcl.xml file, which contains the metadata and data of the source database.

B. The backup fails because the UNPLUG operation for cross-endian platforms is not supported.

C. It successfully takes a backup but the UNPLUG operation of PDB_ORCL fails.

D. It successfully completes.

E. It creates a backupset of the source database in the /home/oracle/backup directory

USER1 is an OS user with the password oracle and is only a member of the oinstall group. In the ORCL database, the OS_AUTHEN_PREFIX value is ops$.

Examine these commands executed by the DBA:

SQL> CREATE USER ops$user1 IDENTIFIED externally;

SQL> GRANT create session TO ops$user1;

How can USER1 be given the SYSRAC privilege?

A. Make User1 a member of the OSDBA group in Linux or the ORA_%HOMENAME%_SYSDBA group in Windows only.

B. Grant SYSRAC to user1.

C. Grant SYSRAC to ops$user1.

D. Make USER1 a member of the OSRACDBA group in Linux or the ORA_%HOMENAME%_SYSRAC group in Windows.

E. Grant SYSDBA to ops$user1

Your CDB is in ARCHIVELOG mode and has an application container with a container PDB. A backup

exists for the CDB. When you connect to the container PDB and try to execute a query, you get an error

that a SYSTEM data file is missing in the container PDB. You want to use the RMAN RESTORE

DATABASE and RECOVER DATABASE commands to perform the recovery.

Examine these actions:

Connect to CDB$ROOT and execute SHUTDOWN ABORT and STARTUP MOUNT.

Connect to the application container and execute SHUTDOWN ABORT.

Connect to the application container and execute ALTER PLUGGABLE DATABASE CLOSE ABORT.

Which option correctly lists the actions that you must execute before performing the recovery?

A. 1 and 3

B. 1 and 2

C. only 2 D. only 3

You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH

MODE EVERY 5 MINUTES clause.

What happens every five minutes?

A. An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.

B. PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete.

C. PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.

D. PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.

E. An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.

In which four situations does the RMAN DUPLICATE command use the "pull" method? (Choose four.)

A. when the USING BACKUPSET clause is used

B. when the SET ENCRYPTION clause is added before the DUPLICATE command

C. when the SECTION SIZE clause is used

D. when the number of auxiliary channels allocated is less than the number of target channels allocated

E. when the USING COMPRESSED BACKUPSET clause is used

F. when no auxiliary channels are allocated

G. when IMAGE COPIES are used for the DUPLICATE operation