[单选]
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（）

A . Checkpoint （CKPT）： 1， 2， 5
B . System Monitor （SMON）： 1， 6
C . Process Monitor （PMON）： 4， 6， 7
D . Database Writer （DBWR）： 1， 3， 4

反形式主义是（）的基本特征。 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？（） Uses undo data for roll forward。 Uses Flashback Log for recovery。 Uses online redo logs to roll back。 Uses undo data to roll back the transaction。 Uses Recovery Manager （RMAN） to roll back。 Uses the System Monitor （SMON） background process to perform instance recovery。说明固相反应的步骤简要叙述市场法的缺点。总承包服务费由建设单位在招标控制价中根据总包服务范围和有关计价规定编制，施工企业投标时自主报价，施工过程中按签约合同价执行。

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（）

参考答案：

● 参考解析

系统监视器进程(SMON) 在实例启动时执行恢复（如果需要）。SMON 还负责清除不再使用的临时段。如果在实例恢复过程中由于文件读取或脱机错误跳过任何已终止的事务处理，则SMON 将在表空间或文件重新联机时恢复这些事务处理。SMON 定期检查以查看是否需要该进程。其它进程在检测到需要SMON 时也可以调用它。

当前位置：1Z0-052题库

相关题目: