For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

Question

Options

• Ato specify a default tablespace in a PDB cloned from another PDB in the same CDB.
• Bto exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
• Cto include specific user tablespaces only when relocating a PDB
• Dto specify the list of user tablespaces to include when moving a non-CDB to a PDB
• Eto exclude a temp tablespace when plugging in a PDB
• Fto specify the list of tablespaces to include when creating a PDB from the CDB seed

• A
  6% (1)
• B
  6% (1)
• C
  6% (1)
• D
  83% (15)

Explanation

A - False : When you create the PDB from the PDB seed or an application seed and specify the DEFAULT TABLESPACE clause, Oracle Database creates a smallfile tablespace and sets it as the default tablespace for the PDB. B, E - False : Specify ALL EXCEPT to include all tablespaces, except for the tablespaces listed. This clause does not apply to the SYSTEM, SYSAUX, or TEMP tablespaces. Do not include these tablespaces in a tablespace list for this clause. C - False : This clause can be used to specify user tablespaces when cloning, creating, or relocating a PDB D - True : For example, when you move a non-CDB to a PDB, and the non-CDB had several schemas that each supported a different application, you can use this clause to separate the data belonging to each schema into a separate PDB. This technique assumes that each schema used a separate tablespace in the non-CDB. F - True : The USER_TABLESPACES clause of the CREATE PLUGGABLE DATABASE statement specifies which tablespaces are available in the new PDB. List one or more tablespaces to include.

No community discussion yet for this question.