OCP CBT 기출문제 예상문제 485번

다음 문제를 풀어보세요.

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.