Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.
How do you achieve this?

• A.This cannot be done due to the lack of a clean restore point.
• B.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
• C.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
• D.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.
• E.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

Comment: *

Name: *

Email: *

Verification: *

RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE; Which two statements are true about the execution of the duplicate command?

• A.The duplicate database is created without using RMAN backups and prod1 is allowed to remain open during duplication.
• B.The duplicate database is created by using the backups created during the execution of
• C.he duplicate command.
• D.The duplicate database has the same directory structure as the source database.
• E.All archive redo log files are automatically copied to the duplicate database.
• F.The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.

Comment: *

Name: *

Email: *

Verification: *

A database is configured in ARCHIVELOGmode.
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? (Choose two.)

• A.after losing all copies of the control file
• B.after losing all members of the CURRENTonline redo log group
• C.after losing an UNDOtablespace that is in use
• D.after losing all members of an INACTIVE online redo log group
• E.after losing a SYSAUXtablespace data file

Comment: *

Name: *

Email: *

Verification: *

choose three Which three RMAN persistent settings can be set explicitly?

• A.control file auto backup formats
• B.image copy duplexing
• C.archive log backup duplexing
• D.redo log backup duplexing
• E.archive log deletion policy
• F.SPFILE backup duplexing

Comment: *

Name: *

Email: *

Verification: *

Which two are true about the Oracle dataabse methodology? (Choose two.)

• A.The alert log should be used to find the database and instance areas most in need of tuning.
• B.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• C.Tuning activities should stop once agreed service levels for performance have been met.
• D.The database instance memory should always be tuned before tuning any file systems.
• E.Tuning activities should stop once the user is satisfied with performance.
• F.SQL statements should always be tuned before tuning any file systems.

Comment: *

Name: *

Email: *

Verification: *