Upgrade to Oracle Database 12c — Question 11

You are connected with SQL*Plus to a multitenant container database (CDB) with SYSDBA privileges and execute these sequence of statements:
SQL> CREATE PLUGGABLE DATABASE NEW_PDB ADMIN USER PDB_ADMIN IDENTIFIED BY SECRET;
SQL> ALTER PLUGGABLE DATABASE NEW_PDB OPEN;
SQL> CONNECT PDB_ADMIN/SCRET@//LOCALHOST/NEW_PDB
What is the outcome of the CONNECT statement?

Answer options

• A. It succeeds because the PDB_ADMIN admin user was implicitly granted the PDB_DBA role.
• B. It results in an ORA-01045 error (user PDB_ADMIN lacks CREATE SESSION privilege; logon denied) because the PDB_ADMIN user was not granted any privileges.
• C. It succeeds because the PDB_ADMIN user was implicitly granted the DBA role.
• D. It succeeds because the PDB_ADMIN user was implicitly granted the SYSDBA privilege.

Correct answer: B

Explanation

The correct answer is B because the PDB_ADMIN user does not have the CREATE SESSION privilege, which is necessary for logging in. Options A, C, and D are incorrect as they incorrectly state that the user was granted roles or privileges that would allow a successful connection, which is not the case here.