1Z0-083 Web TestEngine demo

You are managing this configuration:

1. CDB1 is a container database.
2. PDB1 and PDB2 are two pluggable databases in CDB1.
3. USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.

CDB1 user SYS executes these commands after connecting successfully to PDB2:

Which two are true? (Choose two.)

Select all that apply.

• A

  The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

• B

  The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.

• C

  The insert on USER2.DEPT fails because of the active transaction in the parent container.

• D

  The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

• E

  The inserts on USER1.EMP were rolled back when the session connected to PDB2.

• F

  The insert on USER2.DEPT is uncommitted.

• G

  The inserts on USER1.EMP were committed when the session connected to PDB2.