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 members of an INACTIVE online redo log group
• B.after losing an UNDOtablespace that is in use
• C.after losing all members of the CURRENTonline redo log group
• D.after losing a SYSAUXtablespace data file
• E.after losing all copies of the control file

Comment: *

Name: *

Email: *

Verification: *

You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

• A.All non-Oracle files in the current FRA that have not been backed up already, are backed up.
• B.All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
• C.These backups can be written to disk or SBT.
• D.All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
• E.All Oracle recovery files in the current fast recovery area (FRA) are backed up.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

• A.The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.
• B.SBT tape compression and RMAN backup compression should be used in parallel.
• C.Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
• D.Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
• E.SBT tape compression can be used even if no RMAN compression is configured.

Comment: *

Name: *

Email: *

Verification: *