Oracle
1Z0-063 · Question #219
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 C. It is created and has the CREATE SESSION privilege only in a PDB that is open. 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 scottorcll; SQL> GRANT CREATE SESSION TO c##scott user? Which statement is true about the c##scott user?
Options
- 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.
How the community answered
(60 responses)- A3% (2)
- B13% (8)
- C77% (46)
- D7% (4)
Community Discussion
No community discussion yet for this question.