Oracle Exam 1Z0-083 Topic 8 Question 100 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 100
Topic #: 8

Choose two. 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: SQL> ALTER SESSION SET CONTAINER=pdb1; Session altered. SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ; 1 row created. SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ; 1 row created. SQL> ALTER SESSION SET CONTAINER=pdb2; Session altered. SQL> INSERT INTO user2.dept VALUES(1, 'IT'); Which two are true? Which two are true? (Choose two.)

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 committed.

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.

Show Suggested Answer

Suggested Answer: A, C, D

by Sherita at Aug 27, 2024, 05:49 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-083 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Loren

1 months ago

I wonder if the exam writer had a little too much coffee when they came up with these options. Some of them sound downright comical!

upvoted 0 times

...

Sylvia

1 months ago

Option E can't be right. Why would the inserts on USER1.EMP be rolled back when connecting to PDB2? That doesn't seem realistic.

upvoted 0 times

...

Julio

1 months ago

Option D sounds like the most logical answer. The insert on USER2.DEPT should be a recursive autonomous transaction that gets committed. Wish I had a database to test this on!

upvoted 0 times

Elfriede

1 days ago

User2: Yeah, it makes sense that the insert on USER2.DEPT would be a recursive autonomous transaction.

upvoted 0 times

...

Katina

7 days ago

User1: Option D does seem like the most logical choice.

upvoted 0 times

...

2 months ago

Hmm, I'm not sure about option B. Committing the inserts on USER1.EMP when inserting into USER2.DEPT doesn't sound right. I think options A and D are the way to go.

upvoted 0 times

3 months ago

I think the correct answers are A and F.

upvoted 0 times

...