1z0-083 Exam QuestionsBrowse all questions from this exam
Go to Exam

1z0-083 Exam - Question 38

Examine this configuration:

1. CDB1 is a container database.

2. PDB1 and PDB2 are pluggable databases in CDB1.

3. PDB1 and PDB2 are OPEN in READ WRITE mode.

You execute these commands successfully:

Which two are true? (Choose two.)

Show Answer
Correct Answer: ABE

When executing the 'ALTER SESSION SET CONTAINER = PDB1;' command, the session context changes to the PDB1, and the subsequent 'SHUTDOWN IMMEDIATE' command operates on the PDB1. This results in PDB1 being closed, and any uncommitted transactions in PDB1 being rolled back. The command does not affect the CDB1 as a whole, so CDB1 remains operational, and there is no indication that CDB1 is in MOUNT state. Thus, the correct answers are that PDB1 is closed and uncommitted transactions in PDB1 have been rolled back.

Discussion

15 comments
Sign in to comment
taotsumiauOptions: AB
Jun 11, 2020

I had test this on my lab. the Answer should be AB

you1234Options: AB
Jun 21, 2020

A & B is correct

CyborgQOptions: AB
Aug 3, 2020

A,B is only correct answers

pgtipsOptions: AB
Aug 16, 2020

Should be A & B

janw
Aug 11, 2020

a,b: ok

nobody347Options: AB
Aug 10, 2021

A & B 100%

TrololoshkoOptions: AB
Oct 7, 2022

A & B 100500 %

jackymakOptions: AB
Nov 20, 2022

https://www.oracletutorial.com/oracle-administration/oracle-shutdown/ During the SHUTDOWN IMMEDIATE, all the connected sessions are disconnected immediately, all uncommitted transactions are rolled back, and the database completely shuts down.

_gio_Options: AB
Apr 24, 2023

i think ab

ScottLOptions: AB
May 2, 2023

AB correct

Blob44Options: AB
Jun 28, 2023

https://oracle-base.com/articles/12c/multitenant-connecting-to-cdb-and-pdb-12cr1

GuhborgesOptions: AB
Jul 11, 2023

AB 110%

kaka321Options: AB
Jul 14, 2023

AB is absolutely correct

geddeOptions: AC
Feb 26, 2024

With 19c it does not let you shutdown immediate and says : SQL> shutdown immediate ORA-01097: cannot shutdown while in a transaction - commit or rollback first

jonsnoowOptions: BE
Apr 27, 2024

PDB1 will be in mounted mode actually: SQL> show con_name; CON_NAME ------------------------------ PDB1 SQL> shutdown immediate; Pluggable Database closed. SQL> alter session set container=cdb$root; Session altered. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 MOUNTED