Exam 1z0-062 topic 1 question 52 discussion

Actual exam question from Oracle's 1z0-062

Question #: 52
Topic #: 1

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

A. The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
D. The statement results in an error because there are open PDBs.

Show Suggested Answer

Suggested Answer: B 🗳️
* SHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]
Shuts down a currently running Oracle Database instance, optionally closing and dismounting a database. If the current database is a pluggable database, only the pluggable database is closed. The consolidated instance continues to run.
Shutdown commands that wait for current calls to complete or users to disconnect such as SHUTDOWN NORMAL and SHUTDOWN TRANSACTIONAL have a time limit that the SHUTDOWN command will wait. If all events blocking the shutdown have not occurred within the time limit, the shutdown command cancels with the following message:
ORA-01013: user requested cancel of current operation
* If logged into a CDB, shutdown closes the CDB instance.
To shutdown a CDB or non CDB, you must be connected to the CDB or non CDB instance that you want to close, and then enter

SHUTDOWN -
Database closed.
Database dismounted.
Oracle instance shut down.
To shutdown a PDB, you must log into the PDB to issue the SHUTDOWN command.

SHUTDOWN -
Pluggable Database closed.
Note:
* Prerequisites for PDB Shutdown
When the current container is a pluggable database (PDB), the SHUTDOWN command can only be used if:
The current user has SYSDBA, SYSOPER, SYSBACKUP, or SYSDG system privilege.
The privilege is either commonly granted or locally granted in the PDB.
The current user exercises the privilege using AS SYSDBA, AS SYSOPER, AS SYSBACKUP, or AS SYSDG at connect time.
To close a PDB, the PDB must be open.

by jackymak at Feb. 12, 2022, 10:33 a.m.

Comments

Submit Cancel

jackymak

3 years, 3 months ago

I think it is C. Otherwise, what is going to happen in PDBs?

upvoted 1 times

jackymak

3 years, 3 months ago

tested: PDB will shutdown immediate

upvoted 2 times

NorwayOracle

3 years, 2 months ago

Did the PDB's shutdown by cancel ongoing transactions or did it shut down using immediate or transaction option?

upvoted 2 times

Ray_gk

3 years ago

I have tested this too. For me, the PDB shutdown immediately upon executing the shutdown transactional command from the root container despite the ongoing transaction in the PDB. I did not issue a commit or rollback in the PDB, nor did I use the shutdown immediate command in the root container.

upvoted 1 times

Ray_gk

3 years ago

Based on my test I am going with A. I forgot to mention both the root container and PDB shutdown as if I used the shutdown immediate command. Actually, per Oracle documentation, shutdown immediate or abort are the only valid clauses both the root container and PDBs. Seems as though shutdown immediate is the default if you choose another clause aside from abort.

upvoted 1 times

...