A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING '/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
('/u01/app/oracle/oradata/', '/u02/app/oracle/oradata/');
Which two are true? (Choose two.)

• A.PDB1 must be dropped from CDB1.
• B.DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
• C.PDB_FILE_NAME_CONVERT must be set before executing the command.
• D.PDB1 data files already exist in the correct location.
• E./u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about automatic block repair?

• A.It is not possible for media corrupt blocks.
• B.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
• C.Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
• D.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.
• E.Automatic block repair can repair blocks with no standby database if db_block_checking = TRUE.

Comment: *

Name: *

Email: *

Verification: *

A database is configured in archivelog mode.
Full RMAN backups are taken daily and no backup to trace has been taken of the control file.
A media failure has occurred.
In which two scenarios are complete recovery possible?

• A.when any archived log from, before, or after the most recent backup is corrupt
• B.after losing an archived log from after the most recent backup
• C.after losing the system tablespace
• D.after losing an archived log from before the most recent backup
• E.after losing all copies of the control file

Comment: *

Name: *

Email: *

Verification: *

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

• A.to store backups that would cause the controlfile to become too large.
• B.to allow database duplication without a connection to the auxiliary instance.
• C.to allow database duplication without a connection to the target instance.
• D.to store backup metadata that would cause the controlfile to become too large.
• E.to report on the database schema at an earlier point in time.

Comment: *

Name: *

Email: *

Verification: *

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

• A.Backups can be taken only if the database is in ARCHIVE LOG mode.
• B.Backups must be done incrementally.
• C.Only consistent backups can be created.
• D.The database must be registered in an RMAN catalog.
• E.Backups must be contained in backup sets.
• F.Backups can be done incrementally.

Comment: *

Name: *

Email: *

Verification: *