Oracle Exam 1Z0-067 Topic 11 Question 47 Discussion

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

Question #: 47
Topic #: 11

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.

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

BIt is created in all the PDBs but has 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: D

by Howard at May 09, 2022, 09:11 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-067 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!