Identify three valid methods of opening, pluggable databases (PDBs).
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
AEG
— The “A” option is badly drafted.
SQL> ALTER SESSION SET CONTAINER=CDB$ROOT;
Sesi¾n modificada.
SQL> ALTER PLUGGABLE DATABASE OPEN ALL;
ALTER PLUGGABLE DATABASE OPEN ALL
*
ERROR en lÝnea 1:
ORA-00922: falta la opci¾n o no es vßlida
— For the option A, the correct sentence is:
SQL> ALTER PLUGGABLE DATABASE ALL OPEN;
Base de datos de conexi¾n modificada.
— E
SQL> ALTER SESSION SET CONTAINER=db12cp1;
Sesi¾n modificada.
SQL> ALTER DATABASE OPEN;
Base de datos modificada.
— F
SQL> ALTER SESSION SET CONTAINER=db12cp2;
Sesi¾n modificada.
SQL> ALTER PLUGGABLE DATABASE DB12CP2 OPEN;
Base de datos de conexi¾n modificada.
SQL>
— G
SQL> ALTER PLUGGABLE DATABASE OPEN;
Base de datos de conexi¾n modificada.