Oracle Database 12c Advance Adminstration1z0-063 Test 3

Question : 39 of 40

Marks: +1, -0

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?

It is created in all the PDBs with the CREATE SESSION privilege.
It is created in all the PDBs but has the CREATE SESSION privilege only in CDB $\$$ ROOT.
It is created and has the CREATE SESSION privilege only in a PDB that is open.
It is created only in CDB $\$$ ROOT and has the CREATE SESSION privilege.

Validate

Go to Question:

Prev Question

Next Question