2. The LGWR successfully writes the changes to redo
3. PMON Process commits the process changes
4. SMON Process Writes the data
2
Q. 11 : The process that performs internal operations like Tablespace Coalescing is
1. PMON
2. SMON
3. DBWR
4. ARCH
2
Q. 12 : The process that manages the connectivity of user sessions is
1. PMON
2. SMON
3. SERV
4. NET8
1
Q. 13 : The ARCH process is enabled when the database runs in a
1. PARALLEL Mode
2. ARCHIVE LOG Mode
3. NOARCHIVELOG Mode
4. None of the above
2
Q. 14 : What performs the Check Point in the absence of a CKPT Process
1. DBWR
2. LGWR
3. PMON
4. SMON
2 : At a check point dbwr writes all data to data files from memory. At this time the datafile headers have to be updated by LGWR in the absence of a CKPT process