QUESTION 65、“ENABLE PLUGGABLE

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 and can never contain a PDB.
B. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).
C. The database is created as a non-CDB and can never be plugged into a CDB.
D. The database is created as a non-CDB but can be plugged into an existing CDB.
E. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.
Correct Answer: AD

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:

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.

 

您使用“create database”语句创建了一个新的数据库，而没有指定“ENABLE PLUGGABLE”子句。

不使用“启用可插拔数据库”子句的两种影响是什么?

数据库创建为非cdb，不能包含PDB。

数据库被视为PDB，必须插入到现有的多租户容器数据库(CDB)中。

数据库创建为非CDB，并且永远不能插入到CDB中。

D.数据库创建为非CDB，但可以插入到现有的CDB中。

E.数据库是作为非CDB创建的，但是当第一个PDB被插入时，它将成为一个CDB。

正确答案:广告

 

 

A(不是B，不是E): CREATE DATABASE…启用可插入数据库SQL语句创建一个新的CDB。如果您没有指定ENABLE PLUGGABLE DATABASE子句，那么新创建的数据库是非cdb，并且永远不能包含pdb。

D:您可以通过插入一个非cdb作为PDB来创建PDB。下图描述了创建PDB的选项:

 

 

 

E:在数据库存在的过程中，它可以是一个CDB，也可以是非CDB。您不能将非CDB转换为CDB，也不能将非CDB转换为CDB。您必须在创建时将数据库定义为CDB，然后在这个CDB中创建pdb。