Examine this configuration:
CDB1 is a container database.
PDB1 and PDB2 are pluggable databases in CDB1.
PDB1 and PDB2 are OPEN in READ WRITE mode.
You execute these commands successfully:

Which two are true? (Choose two.)

• A.Uncommitted transactions in PDB1 have been rolled back.
• B.CDB1 is shut down.
• C.Uncommitted transactions in CDB1 and PDB1 have been rolled back.
• D.CDB1 is in MOUNT state
• E.PDB1 is closed.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
* CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
* PDB$SEED is open READ ONLY
* PDB1 is open READ WRITE
* PDB2 is MOUNTED.
* 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, 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: *

Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)

• A.Row Movement must be enabled on the table being flashed back.
• B.The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
• C.The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
• D.A table's indexes must be set to unusable before issuing the flashback.
• E.A table's constraints must be disabled before issuing the flashback.

Comment: *

Name: *

Email: *

Verification: *

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 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_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 non-waiting session last waited.
• F.V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about common objects? (Choose two.)

• A.They can exist in CDB$ROOT and an application root.
• B.They can be created only in CDB$ROOT.
• C.They can be extended data-linked in CDB$ROOT.
• D.They can be only metadata-linked in an application container.
• E.They can be created only in an application root.
• F.They can exist in user-defined schemas only in application containers.

Comment: *

Name: *

Email: *

Verification: *