Oracle Exam 1Z0-063 Topic 9 Question 11 Discussion

Actual exam question for Oracle's 1Z0-063 exam

Question #: 11
Topic #: 9

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?

AIt is created in all the PDBs with the CREATE SESSION privilege.

BIt is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.

CIt is created and has the CREATE SESSION privilege only in a PDB that is open.

DIt is created only in CDB$ROOT and has the CREATE SESSION privilege.

Show Suggested Answer

Suggested Answer: B

by Elli at May 03, 2022, 08:24 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-063 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!