Exam 1z0-063 topic 1 question 214 discussion

Actual exam question from Oracle's 1z0-063

Question #: 214
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by alipilot2006 at April 26, 2019, 7:45 a.m.