Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
(Choose two.)

• A.A failure can be closed only when it has been repaired.
• B.Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.
• C.The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.
• D.Data Recovery Advisor can be used if a database is closed.
• E.Data Recovery Advisor can proactively check for failures.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

• A.ADDM can recommend shrinking the buffer cache.
• B.ADDM can recommend extending the buffer cache.
• C.By default, MMON creates an AWR snapshot every 30 minutes.
• D.ADDM performs its analysis only when a DBA requests it.
• E.By default, AWR snapshots are automatically purged after eight days.
• F.AWR snapshots must be deleted when no longer required by ADDM.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)?

• A.The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
• B.The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
• C.The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
• D.By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
• E.The Oracle Grid Infrastructure Installation must be owned by the grid user.
• F.The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

Comment: *

Name: *

Email: *

Verification: *

You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

• A.The SPFILEis included in the self-contaied archival backup.
• B.All archive logs created after this backup are kept for two years.
• C.The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
• D.The control file is included in the self-contained archival backup.
• E.The restore point is a label for the system change number (SCN) before the archival backup was taken.
• F.The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

Comment: *

Name: *

Email: *

Verification: *

The USERS tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)

• A.Only consistent backups can be created.
• B.Backups must be contained in backup sets.
• C.Backups can be done incrementally.
• D.Backups can be taken only if the database is in ARCHIVE LOG mode.
• E.The database must be registered in an RMAN catalog.
• F.Backups must be done incrementally.

Comment: *

Name: *

Email: *

Verification: *