Oracle
1Z0-083 · Question #75
1Z0-083 Question #75: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #75. The question stem and answer options stay visible for context.
Question
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.)
Exhibit
Options
- AThe inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
- BThe inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
- CThe insert on USER2.DEPT fails because of the active transaction in the parent container.
- DThe insert on USER2.DEPT is a recursive autonomous transaction by the child session and is
- EThe inserts on USER1.EMP were rolled back when the session connected to PDB2.
- FThe insert on USER2.DEPT is uncommitted.
- GThe inserts on USER1.EMP were committed when the session connected to PDB2.
Unlock 1Z0-083 to see the answer
You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.