单选题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（）ACheckpoint （CKPT）： 1， 2， 5BSystem Monitor （SMON）： 1， 6CProcess Monitor （PMON）： 4， 6， 7DDatabase Writer （DBWR）： 1， 3， 4
单选题
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
参考解析
解析：
系统监视器进程(SMON) 在实例启动时执行恢复（如果需要）。SMON 还负责清除不再使用的临时段。如果在实例恢复过程中由于文件读取或脱机错误跳过任何已终止的事务处理，则SMON 将在表空间或文件重新联机时恢复这些事务处理。SMON 定期检查以查看是否需要该进程。其它进程在检测到需要SMON 时也可以调用它。
相关考题：
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 processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?() A. ASMBB. PMONC. RBALD.SMON
Notethefunctionalitiesofvariousbackgroundprocesses：1：Performrecoveryatinstancestartup.SMON2：Freetheresourcesusedbyauserprocesswhenitfails.PMON3：Cleanupthedatabasebuffercachewhenaprocessfails.PMON4：Dynamicallyregisterdatabaseserviceswithlisteners.PMON5：Monitorsessionsforidlesessiontimeout.PMON6：Cleanupunusedtemporarysegments.SMON7：Recordthecheckpointinformationincontrolfile.CKPTWhichoptionhasthecorrectfunctionalitieslistedforabackgroundprocess（）A.Checkpoint（CKPT）：1，2，5B.SystemMonitor（SMON）：1，6C.ProcessMonitor（PMON）：4，6，7D.DatabaseWriter（DBWR）：1，3，4
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， 5B、System Monitor （SMON）： 1， 6C、Process Monitor （PMON）： 4， 6， 7D、Database Writer （DBWR）： 1， 3， 4
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 processB、Server processC、System Monitor (SMON)D、Process Monitor (PMON)E、Checkpoint process (CKPT)
Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）A、 ASMBB、 PMONC、 RBALD、 SMON
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?（）A、DBW0 B、LGWR C、ARCH D、SMON E、PMON
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？（）A、Uses undo data for roll forwardB、Uses Flashback Log for recoveryC、Uses online redo logs to roll backD、Uses undo data to roll back the transactionE、Uses Recovery Manager （RMAN） to roll backF、Uses the System Monitor （SMON） background process to perform instance recovery
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（）A、Archiver Process （ARCn）：1， 2，5B、System Monitor Process （SMON）：1，4，5C、Process Monitor Process （PMON）：4，5，6D、Database Writer Process （DBWn）：1，3，4
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（）A、System monitor （SMON）B、Process monitor （PMON）C、Memory manager process （MMAN）D、Manageability Monitor process （MMON）
One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A、uses undo data for roll forwardB、uses Flashback Log for recoveryC、uses online redo logs to roll backD、uses undo data to roll back the transactionE、uses Recovery Manager （RMAN） to roll backF、uses the System Monitor （SMON） background process to perform instance recovery
You work as a database administrator for Certkiller .com. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）A、PMON coordinates media recovery.B、SMON coordinates instance recovery.C、PMON coordinates instance recovery.D、Undo Advisor would roll back all uncommitted transactions.E、SQL*PLUS reports an error with the message asking you to perform instance recovery.
Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?（）A、ASMBB、PMONC、RBALD、SMON
Which statement is true about the Manageability Monitor （MMON） background process（）A、It transfers statistics from memory to disk at regular intervals.B、It coordinates the rebalance activity for disk groups when ASM is used.C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.D、It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90 Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）A、System monitor （SMON）B、Process monitor （PMON）C、Memory manager process （MMAN）D、Manageability Monitor process （MMON）
Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 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（）A、Archiver Process （ARCn）： 1， 2， 5B、System Monitor Process （SMON）： 1， 4， 5C、Process Monitor Process （PMON）： 4， 5， 6D、Database Writer Process （DBWn）： 1， 3， 4
单选题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（）ASystem monitor （SMON）BProcess monitor （PMON）CMemory manager process （MMAN）DManageability Monitor process （MMON）
单选题One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）Auses undo data for roll forwardBuses Flashback Log for recoveryCuses online redo logs to roll backDuses undo data to roll back the transactionEuses Recovery Manager （RMAN） to roll backFuses the System Monitor （SMON） background process to perform instance recovery
单选题Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）A ASMBB PMONC RBALD SMON
单选题Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 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（）AArchiver Process （ARCn）： 1， 2， 5BSystem Monitor Process （SMON）： 1， 4， 5CProcess Monitor Process （PMON）： 4， 5， 6DDatabase Writer Process （DBWn）： 1， 3， 4
单选题Which statement is true about the Manageability Monitor （MMON） background process（）AIt transfers statistics from memory to disk at regular intervals.BIt coordinates the rebalance activity for disk groups when ASM is used.CIt communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.DIt performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
单选题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?（）AUser processBServer processCSystem Monitor (SMON)DProcess Monitor (PMON)ECheckpoint process (CKPT)
单选题Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 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（）AArchiver Process （ARCn）： 1， 2， 5BSystem Monitor Process （SMON）： 1， 4， 5CProcess Monitor Process （PMON）： 4， 5， 6DDatabase Writer Process （DBWn）： 1， 3， 4
单选题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 processB Server processC System Monitor （SMON）D Process Monitor （PMON）E Checkpoint process （CKPT）
单选题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？（）AUses undo data for roll forwardBUses Flashback Log for recoveryCUses online redo logs to roll backDUses undo data to roll back the transactionEUses Recovery Manager （RMAN） to roll backFUses the System Monitor （SMON） background process to perform instance recovery
单选题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（）AArchiver Process （ARCn）：1， 2，5BSystem Monitor Process （SMON）：1，4，5CProcess Monitor Process （PMON）：4，5，6DDatabase Writer Process （DBWn）：1，3，4
单选题You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90 Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）ASystem monitor （SMON）BProcess monitor （PMON）CMemory manager process （MMAN）DManageability Monitor process （MMON）