Oracle Database 12c: Installation and Administration — Question 201

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

Answer options

• A. It will create a multitenant container database (CDB) with only the root opened.
• B. It will create a CDB with root opened and seed read only.
• C. It will create a CDB with root and seed opened and one PDB mounted.
• D. It will create a CDB that must be plugged into an existing CDB.
• E. It will create a CDB with root opened and seed mounted.

Correct answer: B

Explanation

The correct answer is B because specifying 'ENABLE PLUGGABLE DATABASE' allows for the creation of a multitenant container database (CDB) with the root open and the seed in a read-only state. Other options misrepresent the status of the seed and root or suggest incorrect configurations for the CDB.