Oracle Database Administration II — Question 112

Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:

CREATE PLUGGABLE DATABASE pdb1 -
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT)
CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1';
Which three are true about PDB1? (Choose three.)

Answer options

• A. Service PDB1 is created for remote logins to PDB1.
• B. It is in mount state after creation.
• C. It has no local users.
• D. It has the same number of roles as CDB1.
• E. It has the same common users defined as does CDB1.
• F. It has only local roles.

Correct answer: A, B, D

Explanation

The correct answers are A, B, and D. A is true because when a pluggable database is created, a service is automatically created to facilitate remote connections. B is correct as newly created PDBs start in a mount state. D is accurate since PDB1 inherits the same roles defined in the CDB, though it does not contain local users or common users, making C and E incorrect, and it does not have solely local roles, making F incorrect.