RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:

Which two statements are true about the execution of the duplicate command? (Choose two.)

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

Comment: *

Name: *

Email: *

Verification: *

You notice a performance change in your production Oracle 12c database. You want to knowwhich change caused this performance difference.
Which method or feature should you use?

• A.Compare Period ADDM report
• B.AWR Compare Period report
• C.Active Session History (ASH) report
• D.taking a new snapshot and comparing it with a preserved snapshot

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about unified auditing?

• A.Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
• B.Unified auditing is enabled by setting the audit_trail parameter to db, extended.
• C.A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.
• D.A unified audit trail captures audit information from unified audit policies and audit settings.
• E.Audit records are created for all users except sys.
• F.Audit records are created only for the DML and DDL operations performed on database objects.

Comment: *

Name: *

Email: *

Verification: *

Your database is running in archivelog mode and regular nightly backups are taken. Due to a media
failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup.
3. Perform an incomplete recovery.
4. Relocate the member of the damaged online redo log group to a new location.
5. Open the database with the resetlogs option.
6. Issue a checkpoint and clear the log.
Identify the required steps in the correct order.

• A.6, 3, 4, 5
• B.6, 4, 3, 5
• C.2, 3, 4, 5
• D.1, 3, 4, 5

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about setting the FAST_START_MTTR_TARGETparameter to a nonzero value?
(Choose two.)

• A.The MTTR advisor is enabled only if the value is greater than the default value.
• B.Automatic checkpoint tuning is enabled.
• C.The value of the LOG_CHECKPOINT_INTERVALparameter overrides the value of the FAST_START_MTTR_TARGETparameter.
• D.The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGETparameter.

Comment: *

Name: *

Email: *

Verification: *