What are two effects of not using the "ENABLE PLUGGABLE database" clause?

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?

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?

A.
The database is created as a non-CDB but will become a CDB whenever the first PDB is
plugged in.

B.
The database is created as a non-CDB and can never contain a PDB.

C.
The database is treated as a PDB and must be plugged into an existing multitenant
container database (CDB).

D.
The database is created as a non-CDB and can never be plugged into a CDB.

E.
The database is created as a non-CDB but can be plugged into an existing CDB.

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


rodge

rodge

Yep, B and E

https://docs.oracle.com/database/121/CNCPT/cdbovrvw.htm#CNCPT89243

“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.”

If you have a non-CDB 12c DB, then of course it can then be plugged into a different CDB.