You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause. What are two effects of not using the "ENABLE PLUGGABLE database" clause?

Question

Options

• AThe database is created as a non-CDB and can never contain a PDB.
• BThe database is treated as a PDB and must be plugged into an existing multitenant container
• CThe database is created as a non-CDB and can never be plugged into a CDB.
• DThe database is created as a non-CDB but can be plugged into an existing CDB.
• EThe database is created as a non-CDB but will become a CDB whenever the first PDB is plugged

• A
  71% (39)
• B
  16% (9)
• C
  7% (4)
• E
  5% (3)

Explanation

A (not B,not E): The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs. D: You can create a PDB by plugging in a Non-CDB as a PDB. The following graphic depicts the options for creating a PDB: Not E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.

No community discussion yet for this question.