Exam 1z0-083 topic 1 question 60 discussion

sure is A,D: Version 19.6.0.0.0 SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY YES 3 PDB1 READ WRITE YES 4 PDB2 READ WRITE YES 5 PDB3 MOUNTED SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. . Database mounted. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 PDB1 MOUNTED 4 PDB2 MOUNTED 5 PDB3 MOUNTED SQL>

I think A, D are correct. When a CDB is mounted, the CBD root is mounted, which means that the control files are opened, as well as the PDBs.

I'm sure AD

AD correct. See Julica

In the MOUNT state, just the controlfile is opened , not redo logs nor datafiles. As the root container is mounted, i.e. not touching any datafiles, no pluggable database can be more than mounted as well.

A, D are correct.

AD, demonstrated by Julica

SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 TEST READ WRITE NO 5 TEST3 MOUNTED SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 6442446872 bytes Fixed Size 9154584 bytes Variable Size 3288334336 bytes Database Buffers 3137339392 bytes Redo Buffers 7618560 bytes Database mounted. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 TEST MOUNTED 5 TEST3 MOUNTED AD correct

what is the current

AD it is

AD for me

Answer: A,D Version 19.3.0.0.0 SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 2147482344 bytes Fixed Size 9136872 bytes Variable Size 637534208 bytes Database Buffers 1493172224 bytes Redo Buffers 7639040 bytes Database mounted. SQL> SELECT NAME, CON_ID, OPEN_MODE FROM V$CONTAINERS ORDER BY CON_ID; NAME CON_ID OPEN_MODE -------- ---------- ---------- CDB$ROOT 1 MOUNTED PDB$SEED 2 MOUNTED PDB1 3 MOUNTED PDB2 4 MOUNTED

AD for sure