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?
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.