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 scottorcl1;SQL> GRANT CREATE SESSION TO c##scott;Which statement is true about the C##SCOTT user? Choose the best answer.
Question:
Which statement is true about the C##SCOTT user?
Options:
It is created in all the PDBs with CREATE SESSION privilege.
It is created in all the PDBs but has CREATE SESSION privilege only in CDB$ROOT.
It is created and has the CREATE SESSION privilege only in a PDB that is open.
It is created only in CDB$ROOT and has the CREATE SESSION privilege.
Correct Answer
The Correct Answer for this Question is
It is created only in CDB$ROOT and has the CREATE SESSION privilege.
