OCP CBT Question 485

Please solve the following question.

Examine the SQL command sequence. What is the expected outcome of executing these commands?

sql CREATE PLUGGABLE DATABASE sales_pdb ADMIN USER pdb_admin IDENTIFIED BY oracle; ALTER PLUGGABLE DATABASE sales_pdb OPEN;

The PDB SALES_PDB is created, and it is automatically opened in READ WRITE mode.

The PDB SALES_PDB is created, but it remains in MOUNTED state and must be explicitly opened.

The command sequence will fail because an explicit tablespace clause is missing.

The PDB SALES_PDB is created, but the ADMIN USER clause is invalid and will cause an error.