Checkpoint （CKPT）： 1， 2， 5
System Monitor （SMON）： 1， 6
Process Monitor （PMON）： 4， 6， 7
Database Writer （DBWR）： 1， 3， 4
第1题：
Notethefunctionalitiesofvariousbackgroundprocesses：1：Performrecoveryatinstancestartup.SMON2：Freetheresourcesusedbyauserprocesswhenitfails.PMON3：Cleanupthedatabasebuffercachewhenaprocessfails.PMON4：Dynamicallyregisterdatabaseserviceswithlisteners.PMON5：Monitorsessionsforidlesessiontimeout.PMON6：Cleanupunusedtemporarysegments.SMON7：Recordthecheckpointinformationincontrolfile.CKPTWhichoptionhasthecorrectfunctionalitieslistedforabackgroundprocess（）
A.Checkpoint（CKPT）：1，2，5
B.SystemMonitor（SMON）：1，6
C.ProcessMonitor（PMON）：4，6，7
D.DatabaseWriter（DBWR）：1，3，4
系统监视器进程(SMON)在实例启动时执行恢复（如果需要）。SMON还负责清除不再使用的临时段。如果在实例恢复过程中由于文件读取或脱机错误跳过任何已终止的事务处理，则SMON将在表空间或文件重新联机时恢复这些事务处理。SMON定期检查以查看是否需要该进程。其它进程在检测到需要SMON时也可以调用它。
第2题：
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）
第3题：
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）
A. User process
B. Server process
C. System Monitor (SMON)
D. Process Monitor (PMON)
E. Checkpoint process (CKPT)
第4题：
Note the following functionalities of various background processes： 1：Record the checkpoint information in data file headers. CKPT 2：Perform recovery at instance startup. SMON 3：Cleanup unused temporary segments. SMON 4：Free the resources used by a user process when it fails. 5：Dynamically register database services with listeners. 6：Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process（）
第5题：
During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）
第6题：
Note the functionalities of various background processes： 1：Perform recovery at instance startup. SMON 2：Free the resources used by a user process when it fails. PMON 3：Cleanup the database buffer cache when a process fails. PMON 4：Dynamically register database services with listeners. PMON 5：Monitor sessions for idle session timeout. PMON 6：Cleanup unused temporary segments. SMON 7：Record the checkpoint information in control file. CKPT Which option has the correct functionalities listed for a background process（）
第7题：
Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）
第8题：
A. ASMB
B. PMON
C. RBAL
D.SMON
第9题：
You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
第10题：
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows：Warning （%）： 90Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）