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.)
Exam 1z0-083 All QuestionsBrowse all questions from this exam
Question 38
Correct Answer: A, B
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
taotsumiauOptions: AB
I had test this on my lab. the Answer should be AB
you1234Options: AB
A & B is correct
pgtipsOptions: AB
Should be A & B
CyborgQOptions: AB
A,B is only correct answers
janw
a,b: ok
nobody347Options: AB
A & B 100%
TrololoshkoOptions: AB
A & B 100500 %
jackymakOptions: AB
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.
jonsnoowOptions: BE
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
geddeOptions: AC
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
kaka321Options: AB
AB is absolutely correct
GuhborgesOptions: AB
AB 110%
Blob44Options: AB
https://oracle-base.com/articles/12c/multitenant-connecting-to-cdb-and-pdb-12cr1
ScottLOptions: AB
AB correct
_gio_Options: AB
i think ab