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

Comment: *

Name: *

Email: *

Verification: *

Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

• A.Data file 24 must be recovered while the CDB is opened.
• B.Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
• C.Data file 24 must be recovered while PDB2 is closed.
• D.Data file 24 can be recovered while PDB2 is opened.
• E.Data file 24 cannot be recovered while the CDB is opened.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

• A.FLASHBACK LOGS are archived after a log switch.
• B.A database can be flashed back using SQL*PLUS.
• C.Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
• D.FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
• E.It always generates REDO and UNDO.
• F.It requires that the target database be in ARCHIVELOG mode.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration: 1. CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2. 2. PDB$SEED is open READ ONLY 3. PDB1 is open READ WRITE 4. PDB2 is MOUNTED. 5. ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1. You execute these commands before upgrading the database to the current release: For which databases will fixup scripts be created?

• A.CDB1, PDB$SEED, PDB1, and PDB2
• B.CDB1 and PDB$SEED only
• C.PDB$SEED, PDB1, and PDB2 only
• D.CDB1, PDB$SEED, and PDB1 only
• E.CDB1, PDB1, and PDB2 only

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:

You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

• A.CDB1, PDB1, and PDB2 only
• B.CDB1, PDB$SEED, PDB1, and PDB2
• C.PDB$SEED, PDB1, and PDB2 only
• D.CDB1 and PDB$SEED only
• E.CDB1, PDB$SEED, and PDB1 only

Comment: *

Name: *

Email: *

Verification: *