In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?

The correct answer is A. The CDB must be open.. Creating a PDB Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.)

Managing the Database Instance

Question

Options

AThe CDB must be open.
BThe CDB must be in the mount stage.
CThe CDB must be in the nomount stage.
DAlt existing PDBs must be closed.

How the community answered

(61 responses)

A
95% (58)
B
2% (1)
D
3% (2)

Explanation

Creating a PDB Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it.

Topics

#PDB creation#multitenant#CDB state#SQL Developer

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice