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.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• C.RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
• D.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
• E.RMAN disk-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 TARGET instance.
• G.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
• H.The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVE LOG mode.

Comment: *

Name: *

Email: *

Verification: *

Which two are true in Oracle 19c and later releases?

• A.If the password file location changes, then the new location is used automatically by the Oracle Server.
• B.All the Oracle-supplied accounts are Schema Only accounts.
• C.Unified Auditing can be configured to audit only events that are issued directly by an audited user.
• D.Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
• E.Schema Only accounts can be granted administrator privileges.

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?

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about monitoring waits for sessions and services?

• A.v$session_wait and v$session both contain details of the event on which a non-waiting session last waited.
• B.v$session_wait_class displays waits broken down by wait class only for waiting sessions.
• C.v$service_event displays wait counts for every wait event whether waited on or not, for each service.
• D.v$session_event displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
• E.v$session_wait and v$session both contain details of the event on which a waiting session is currently waiting.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A.It is part of the DBMS_ADVISOR package.
• B.It is part of the DBMS_STATS package.
• C.It can recommend changes to improve the statistics gathering process.
• D.It can be run only manually.
• E.It always analyzes all schemas in the database.
• F.It runs automatically every night by default.

Comment: *

Name: *

Email: *

Verification: *