Oracle
1Z0-067 · Question #19
Examine the command to create a pluggable database (PDB): SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1 FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PREFIX =…
The correct answer is A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state. C. The tablespace specifications of pdb2 are the same as pdb1. https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13586
Core Concepts and Tools
Question
Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1 FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PREFIX = '/disk2/oracle/pdb2'; Which two statements are true?
Options
- AThe pluggable database pdb2 is created by cloning pdb1 and is in mount state.
- BDetails about the metadata describing pdb2 are stored in an XML file in the'/disk2/oracle/pdb2/'
- CThe tablespace specifications of pdb2 are the same as pdb1.
- DAll database objects belonging to common users in PD3I are cloned in PD32.
- Epdb2 is created with its own private undo and temp tablespaces.
How the community answered
(18 responses)- A72% (13)
- B6% (1)
- D17% (3)
- E6% (1)
Explanation
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13586
Topics
#PDB cloning#CREATE PLUGGABLE DATABASE#FILE_NAME_CONVERT#multitenant
Community Discussion
No community discussion yet for this question.