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

Posted on 29/10/2024 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

0 Góp ý

Phản hồi nội tuyến

Xem tất cả bình luận