Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

• A.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• B.The UNDO TABLESPACE clause is never required.
• C.The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
• D.RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
• E.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

Comment: *

Name: *

Email: *

Verification: *

Which three actions will add a resource to an Oracle Restart configuration? (Choose three.)

• A.creating a database service using DBMS_SERVICE.CREATE_SERVICE
• B.creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)
• C.creating a database using the CREATE DATABASE SQL statement
• D.creating a database service using Oracle Database Configuration Assistant (DBCA)
• E.creating an Oracle Database service by modifying the SERVICE_NAMES parameter
• F.creating a disk group using the CREATE DISKGROUP SQL statement

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
* CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
* PDB$SEED is open READ ONLY
* PDB1 is open READ WRITE
* PDB2 is MOUNTED.
* ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

• A.CDB1, PDB1, and PDB2 only
• B.CDB1, PDB$SEED, PDB1, and PDB2
• C.CDB1, PDB$SEED, and PDB1 only
• D.PDB$SEED, PDB1, and PDB2 only
• E.CDB1 and PDB$SEED only

Comment: *

Name: *

Email: *

Verification: *

A database is configured in archivelog mode.
A full RMAN backup exists but no control file backup to trace has been taken.
A media failure has occurred.
In which two scenarios is incomplete recovery required?

• A.after losing a sysaux tablespace data file
• B.after losing all members of an inactive online redo log group
• C.after losing all copies of the control file
• D.after losing all members of the current online redo log group
• E.after losing an undo tablespace that is in use

Comment: *

Name: *

Email: *

Verification: *

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)

• A.CDB1 and CDB2 must be in shared undo mode.
• B.The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.
• C.A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
• D.Cloning HR_ROOT automatically clones HR_PDB1.
• E.All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.

Comment: *

Name: *

Email: *

Verification: *