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

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

Comment: *

Name: *

Email: *

Verification: *

Which three are true about requirements for various FLASHBACKoperations? (Choose three.)

• A.FLASHBACKtransaction query requires undo to retrieve all versions of a row that existed between two points in time.
• B.FLASHBACKdrop requires that the RECYCLEBIN parameter be set to ON.
• C.FLASHBACKversion query requires that the RECYCLEBINparameter be set to ON.
• D.FLASHBACK DATA ARCHIVErequires undo to store all versions of all rows of a table being tracked.
• E.FLASHBACKdrop requires undo to retrieve all versions of a row that existed between two points in time.
• F.FLASHBACKversion query requires undo to retrieve all versions of a row that existed between two points in time.

Comment: *

Name: *

Email: *

Verification: *

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

• A.The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
• B.The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
• C.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• D.The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
• E.RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
• F.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
• G.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
• H.RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about managing memory components in an Oracle database instance?

• A.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• B.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• C.Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• D.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• E.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
• F.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

Comment: *

Name: *

Email: *

Verification: *

Examine these queries and their output:

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

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

Comment: *

Name: *

Email: *

Verification: *