Which three are true about monitoring waits for sessions and services? (Choose three.)

• A.V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
• B.V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
• C.V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
• D.V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
• E.V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
• F.V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about gathering optimizer statistics?

• A.Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics only in cdbSroot.
• B.System statistics can be gathered only while connected to cdb$root.
• C.Executing dbms_stats.gather_database_stats while connected to a PDBopened in read/write mode gathers object statistics for that PDB.
• D.Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open PDBs except pdb$seed.
• E.Executing dbms_stats.gather_database_stats while connected to cdb$root gathers object statistics in all open pluggable databases (PDBs).

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Recovery Manager (RMAN) diagnostic message output?

• A.Media Management messages for SBT devices are written to an Oracle trace file.
• B.The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
• C.Media Management messages for SBT devices are always written to sbtio.log.
• D.RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
• E.The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
• F.RMAN error stacks should be read from the top down as that is the order in which errors are generated.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment?

• A.AWR snapshots can be created in CDB$ROOT.
• B.All AWR data is stored in the CDB$ROOT SYSAUX tablespace.
• C.AWR snapshots can be created in a PDB.
• D.AWR reports can be generated while connected to any container.
• E.ADDM can run in a nonroot container.
• F.No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RMAN duplexed backup sets? (Choose two.)

• A.A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.
• B.A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.
• C.A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.
• D.A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.
• E.A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.
• F.A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

Comment: *

Name: *

Email: *

Verification: *