You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command. What is the outcome?

The correct answer is B. The PDB is placed in mount state. The PDB is placed in mount state. SQL> shutdown immediate; Pluggable Database closed. SQL> select status from v$instance; There is no closed Status in a PDB. PDB can have Mount/Read Write/Read Only.

New Features for Database Infrastructure and Architecture

Question

Options

AThe PDB is closed.
BThe PDB is placed in mount state.
CThe command executes only if the common user is granted the set container privilege for the
DThe command results in an error because the PDB can be shut down only by a local user.

How the community answered

(36 responses)

A
11% (4)
B
69% (25)
C
14% (5)
D
6% (2)

Explanation

The PDB is placed in mount state. SQL> shutdown immediate; Pluggable Database closed. SQL> select status from v$instance; There is no closed Status in a PDB. PDB can have Mount/Read Write/Read Only.

Topics

#PDB shutdown#multitenant#sysdba privilege#PDB mount state

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice