Oracle
1Z0-068 · Question #133
Examine this command: SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1; Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)
The correct answer is A. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system C. The source PDB must be in READ ONLY mode on all CDB instances. D. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set. See the full explanation below for the reasoning.
Question
Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1; Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)
Options
- AIt can be executed only by a common user with the CREATE PLUGGABLE DATABASE system
- BThe source PDB must use a global temporary tablespace.
- CThe source PDB must be in READ ONLY mode on all CDB instances.
- DOracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.
- EAll running CDB instances must be open in restricted mode.
- FThe source PDB must be closed on the CDB instance from where the command is executed.
How the community answered
(47 responses)- A85% (40)
- B4% (2)
- E2% (1)
- F9% (4)
Community Discussion
No community discussion yet for this question.