Choose two. Which two are true about RMAN persistent configuration settings, administration, and their effects?

• A.A target database's persistent RMAN configuration settings are always stored in the target's control file.
• B.Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.
• C.Backups older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
• D.A DBA must specify either a redundancy retention policy or a recovery window retention policy. B)A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

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.All archive redo log files are automatically copied to the duplicate database.
• C.The duplicate database has the same directory structure as the source database.
• D.he duplicate command.
• E.The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.
• F.The duplicate database is created by using the backups created during the execution of

Comment: *

Name: *

Email: *

Verification: *

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

• A.It is integrated with the SQL Access Advisor.
• B.It predicts the impact of system changes on SQL workload response time.
• C.It provides before and after execution statistics for each SQL statement in the analysis task
• D.It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
• E.SQL statements that were originally run concurrently are run concurrently by SPA.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c?
(Choose two.)

• A.It cannot be used to upgrade Oracle Database homes.
• B.It can be used to provision applications.
• C.It is an Oracle Database service
• D.It can be used to provision middleware.
• E.It can be used to patch Grid Infrastructure homes containing Oracle Restart.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *