Q64. Examine this configuration

Posted on by Tran Anh

Q64. Examine this configuration:
1. CDB1 is a container database.
2. APP1_ROOT is an application container contained in CDB1.
3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT.
4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT.
5. APP1_USER1_APP is an application installed in APP1_ROOT at version 1.0
6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0 of APP1_USER_APP was installed.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> ALTER SESSION SET CONTAINER=app1_root;
Session altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE ‘1.0’ TO ‘2.0’;
Pluggable database altered.

SQL> GRANT CREATE SESSION TO USER1;
Grant succeeded.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE TO ‘2.0’;
Pluggable database altered.

SQL> ALTER SESSION SET CONTAINER=app1_pdb1;
Session altered.

SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC;
Pluggable database altered.

Which two are true?

  • A. USER1 can connect only to APP1_ROOT.
  • B. USER1 can connect to CDB1.
  • C. USER1 can connect only to APP1_PDB1.
  • D. USER1 is defined in APP1_PDB2.
  • E. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.
  • F. USER1 can connect to APP1_ROOT and APP1_PDB1.
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