Q137. 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.)
- 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.
Answer: AC