Upgrade to Oracle Database 12c — Question 14

Identify three valid methods of opening, pluggable databases (PDBs).

Answer options

• A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
• B. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB
• C. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
• D. ALTER DATABASE PDB OPEN issued from the root
• E. ALTER DATABASE OPEN issued from that PDB
• F. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB
• G. ALTER PLUGGABLE DATABASE OPEN issued from that PDB

Correct answer: A, E, G

Explanation

The correct methods for opening PDBs are A, E, and G. Option A allows opening all PDBs from the root, option E opens a specific PDB from within itself, and option G opens a PDB from its own context. The other options are incorrect because they either use invalid syntax or attempt to open PDBs from inappropriate contexts.