QUESTION 66/ENABLE PLUGGABLE DATABASE

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?
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

* 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. Along with the root (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). The following graphic shows a newly created CDB:

 

在“CREATE DATABASE”语句中指定“ENABLE PLUGGABLE DATABASE”子句的效果是什么?

它将创建一个多租户容器数据库(CDB)，只打开根。

它将创建一个根打开，种子只读的CDB。

它将创建一个打开根和种子的CDB，并安装一个PDB。

它将创建一个必须插入到现有CDB的CDB。

它将创建一个打开根并挂载种子的CDB。

正确答案是:B

 

 

*创建数据库…启用可插入数据库SQL语句创建一个新的CDB。如果您没有指定ENABLE PLUGGABLE DATABASE子句，那么新创建的数据库是非cdb，并且永远不能包含pdb。除了根(CDB$ root)， Oracle数据库还自动创建一个种子PDB (PDB$ seed)。下图显示了一个新创建的CDB: