Oracle
1Z0-063 · Question #151
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. See the full explanation below for the reasoning.
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
(31 responses)- A77% (24)
- B3% (1)
- D6% (2)
- E13% (4)
Community Discussion
No community discussion yet for this question.