Q75 It will return an error because creation of a local role is not allowed in CDB$ROOT

Posted on by Tran Anh

Q75. Examine this configuration:
1. CDB1 is a container database.
2. COMMON_USER_PREFIX is set to empty string.
3. PDB1 is a pluggable database in CDB1.
4. APP1_ROOT is an application container in CDB1.
5. APP1_PDB1 is an application PDB in APP1_ROOT.

You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> CREATE ROLE role1 CONTAINER=CURRENT;

Which is true?

  • A. It will return an error because creation of a local role is not allowed in CDB$ROOT.
  • B. ROLE1 will be created only in CDB$ROOT and APP1_ROOT.
  • C. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
  • D. ROLE1 will be created only in CDB$ROOT.
  • E. It will return an error because common roles must start with c##.
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