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: