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

다음 문제를 풀어보세요.

You are creating a new PDB, `FINANCE_PDB`, within a CDB configured for `SHARED UNDO`. You want `FINANCE_PDB` to use its own dedicated undo tablespace. Examine the following SQL command: ```sql CREATE PLUGGABLE DATABASE finance_pdb ADMIN USER pdb_admin IDENTIFIED BY oracle DEFAULT TABLESPACE users; ``` What is the most likely outcome regarding the undo configuration for `FINANCE_PDB`?

The CDB parameter UNDO_MANAGEMENT is set to AUTO. The CDB is in SHARED UNDO mode.

FINANCE_PDB will automatically use a local undo tablespace, as it's the default behavior for new PDBs in a SHARED UNDO CDB.

FINANCE_PDB will inherit the SHARED UNDO configuration from the CDB and use the CDB's undo tablespace.

The CREATE PLUGGABLE DATABASE command will fail because LOCAL UNDO must be explicitly specified when creating a PDB in a SHARED UNDO CDB.

FINANCE_PDB will be created, but it will require a separate ALTER PLUGGABLE DATABASE ... LOCAL UNDO ON command to enable local undo.