Q137. You are managing this configuration: CDB1 user SYS executes these commands after connecting successfully to PDB2

Posted on by Tran Anh

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:

https://www.examtopics.com/assets/media/exam-media/03747/0002100001.png

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.

 

Xem thêm:

Bài viết cùng chủ đề:

0 0 đánh giá
Đánh giá bài viết
Theo dõi
Thông báo của
guest
0 Góp ý
Phản hồi nội tuyến
Xem tất cả bình luận