A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

• A.V$SESSION_WAIT
• B.V$SESSION
• C.V$SESSION_WAIT_CLASS
• D.V$SESSION_EVENT
• E.V$SESSTAT

Comment: *

Name: *

Email: *

Verification: *

Which three are true about patchsets? (Choose three.)

• A.They are installed via OPatch or OPatchAuto.
• B.They can introduce new features.
• C.Installing a patchset is considered an "upgrade".
• D.A base release is not needed to install patchsets.
• E.They are only released quarterly.
• F.They can be applied in a rolling fashion for Clusterware and the databases.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

• A.All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
• B.A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
• C.The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
• D.CDB$ROOT and PDB$SEED are automatically duplicated.
• E.Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.

Comment: *

Name: *

Email: *

Verification: *

Which three are true in Oracle 19c and later releases? (Choose three.)

• A.If the password file location changes, then the new location is used automatically by the Oracle Server.
• B.Schema Only accounts can be granted administrator privileges.
• C.All the Oracle-supplied accounts are Schema Only accounts.
• D.Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
• E.Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
• F.Unified Auditing can be configured to audit only events that are issued directly by an audited user.

Comment: *

Name: *

Email: *

Verification: *