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
Explanation:
E: You can perform all ALTER PLUGGABLE DATABASE tasks by connecting to a
PDB and running the corresponding ALTER DATABASE statement. This functionality is provided
to maintain backward compatibility for applications that have been migrated to a CDB
environment.
AG: When you issue an ALTER PLUGGABLE DATABASE OPEN statement, READ WRITE is the
default unless a PDB being opened belongs to a CDB that is used as a physical standby
database, in which case READ ONLY is the default.
You can specify which PDBs to modify in the following ways:
List one or more PDBs.
Specify ALL to modify all of the PDBs.
Specify ALL EXCEPT to modify all of the PDBs, except for the PDBs listed.
A E G
— 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.
A,E,G.
to open PDB=test1
from root container:
ALTER PLUGGABLE DATABASE ALL OPEN;
or
ALTER PLUGGABLE DATABASE test1 OPEN;
from PDB=test1 container:
ALTER SESSION SET container = test1;
ALTER PLUGGABLE DATABASE OPEN;
or
ALTER PLUGGABLE DATABASE test1 OPEN;
or
ALTER DATABASE OPEN;
or
ALTER DATABASE test1 OPEN;
ALTER SESSION SET container = cdb$root;