Which two statements are true about the c##admin user t…

You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:

SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123; SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;

Which two statements are true about the c##admin user that is created in all PDBs?

You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:

SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123; SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;

Which two statements are true about the c##admin user that is created in all PDBs?

A.
It can create only local users in all the PDBs.

B.
It has a common schema for all the PDBs.

C.
It can create common users only when it is logged in to the CDB.

D.
It can create only local users in the CDB.

E.
It can be granted only common roles in the PDBs.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


ismaelv90

ismaelv90

I think A,C