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?

Question

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?

Accepted Answer

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.

Answer

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

Answer

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

Answer

E. It can be granted only common roles in the 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…

Question

Options

How the community answered

Community Discussion