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

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

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Fred

Fred

A, E and G are indeed correct, but only if A says:
ALTER PLUGGABLE DATABASE ALL OPEN; and NOT: ALTER PLUGGABLE DATABASE OPEN ALL.

Alexis

Alexis

— 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.