Oracle
1Z0-067 · Question #196
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…
The correct answer is D. It is created only in CDB$ROOT and has the CREATE SESSION privilege. See the full explanation below for the reasoning.
Question
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.
Options
- 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.
How the community answered
(54 responses)- A4% (2)
- B19% (10)
- C7% (4)
- D70% (38)
Community Discussion
No community discussion yet for this question.