1Z0-060 · Question #87
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. 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…
Question
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?
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
(27 responses)- A93% (25)
- B4% (1)
- D4% (1)
Explanation
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 gigabyteand it takes only a few seconds on a typical machine to copy it.
Topics
Community Discussion
No community discussion yet for this question.