Choose three. Which three are true about block media recovery?

• A.To use it, Flashback Database must be enabled.
• B.It can be performed on noncorrupt blocks.
• C.The target database for which one or more blocks are to be recovered must be in the OPEN state.
• D.A block being recovered is not accessible.
• E.The data file containing the block being recovered remains online.
• F.It cannot repair logical corruption.

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?

• A.It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.
• B.It creates a full export of the root
• C.It creates a full export of the root
• D.It fails because Data Pump cannot be container.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about the tools for diagnosing Oracle Database failure situations?

• A.RMAN can always repair corrupt blocks.
• B.The ADR can store metadata in an Oracle Database repository.
• C.Flashback commands help with repairing physical errors.
• D.The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.
• E.The Data Recovery Advisor uses the ADR.
• F.The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration: While CDB1 is open, '/u02/app/oracle/fast_recover_area/cdb1/CDB1/ controlfile02.ctl'is accidentally deleted. To recover from this critical failure, you execute these commands:
What will be the outcome?

• A.It will re-create '/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl'
• B.It will create '/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl'.
• C.It will create '$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl'
• D.It will fail because there is no autobackup of the controlfiles.
• E.It will create '/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl'.

Comment: *

Name: *

Email: *

Verification: *