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$SESSTAT
• C.V$SESSION_EVENT
• D.V$SESSION_WAIT_CLASS
• E.V$SESSION

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases?

• A.A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• B.A Virtual Private Catalog used to register a container database can be created in a pluggable database.
• C.It Is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• D.It Is always possible for RMAN to connect to a pluggable database as a target.
• E.It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• F.A Virtual Private Catalog used to register a container database can be created in a non-container database.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about the SQL Tuning Advisor?

• A.It checks each query being analyzed for missing or stale statistics.
• B.It considers all SQL statements being analyzed by the advisor task as a group.
• C.It can recommend semantic changes to SQL statements.
• D.It only recommends syntactic changes to SQL statements.
• E.It prevents performance regressions for SQL statements when changes are made.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance?

• A.The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
• B.Sorts and Hash Joins use PGA memory.
• C.PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
• D.The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
• E.The entire PGA is located in the System Global Area (SGA) when using shared servers.

Comment: *

Name: *

Email: *

Verification: *

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)

• A.Data file 24 can be restored only while connected to PDB2.
• B.Data file 24 can be recovered while connected to PDB2.
• C.Data file 24 can be restored and recovered while connected to CDB$ROOT.
• D.Data file 24 can be recovered while connected to CDB$ROOT.
• E.Data file 24 can be recovered only while connected to PDB2.
• F.Data file 24 can be restored only while connected to CDB$ROOT.

Comment: *

Name: *

Email: *

Verification: *