OCP CBT Question 494

Please solve the following question.

You are attempting to create a new PDB, `REPORT_PDB`, within `CDB01`. You want to specify a temporary tablespace for the new PDB. Examine the following command: ```sql CREATE PLUGGABLE DATABASE report_pdb ADMIN USER rep_admin IDENTIFIED BY oracle DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp_rep; ``` Which statement is true if `temp_rep` is an existing temporary tablespace defined at the CDB root level?

CDB01 has a temporary tablespace named temp_rep.

The command will succeed, and REPORT_PDB will use temp_rep as its dedicated temporary tablespace.

The command will fail because PDBs cannot have their own dedicated temporary tablespaces.

The command will fail because a temporary tablespace specified during PDB creation must be a new, PDB-specific temporary tablespace, not one from the CDB root.

The command will succeed, but REPORT_PDB will share the CDB's default temporary tablespace instead of temp_rep.