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

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

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:

To recover from this critical failure, you execute these commands:

What will be the outcome?

• A.Option
  
• B.Option
  
• C.Option
  
• D.Option
  
• E.Option
  

Comment: *

Name: *

Email: *

Verification: *

Which four are true about RMAN backup sets?

• A.A backup set must be written to media.
• B.Blocks from multiple data files can be contained in one backup piece.
• C.A backup set must be written to disk.
• D.A data file can be split into multiple sections stored in different backup pieces in the same backup set.
• E.Blocks from multiple data files can be contained in one backup set.
• F.A backup set can contain only one backup piece.
• G.A data file can be split into multiple sections stored in different backup sets.
• H.A backup piece can belong to only one backup set.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about the Oracle Optimizer?

• A.It considers the filters in WHERE clauses when generating execution plans for SQL statements.
• B.It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.
• C.It obeys all hints.
• D.It considers object statistics when generating execution plans for SQL statements.
• E.It can re-optimize execution plans after previous executions detect suboptimal plans.
• F.It updates stale object statistics in the Data Dictionary.

Comment: *

Name: *

Email: *

Verification: *