Oracle Database 12c: Advanced Administration — Question 14

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcll;
SQL> GRANT CREATE SESSION TO c##scott user?
Which statement is true about the c##scott user?

Answer options

• A. It is created in all the PDBs with the CREATE SESSION privilege.
• B. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.
• C. It is created and has the CREATE SESSION privilege only in a PDB that is open.
• D. It is created only in CDB$ROOT and has the CREATE SESSION privilege.

Correct answer: C

Explanation

The correct answer is C because the user c##scott is created in the CDB$ROOT and receives privileges only in the PDBs that are currently open. Options A and B are incorrect as they suggest the user has privileges in all PDBs, which is not true. Option D is also incorrect because it implies the user is limited to CDB$ROOT only, disregarding the possibility of being granted privileges in an open PDB.