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
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，5
- B、System Monitor Process （SMON）：1，4，5
- C、Process Monitor Process （PMON）：4，5，6
- D、Database Writer Process （DBWn）：1，3，4
相关考题：
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
Notethefollowingfunctionalitiesofvariousbackgroundprocesses：1：Record thecheckpointinformationindatafileheaders.CKPT2：Performrecoveryatinstancestartup.SMON3：Cleanupunusedtemporarysegments.SMON4：Freetheresourcesusedbyauserprocesswhenitfails.5：Dynamicallyregisterdatabaseserviceswithlisteners.6：Monitorsessionsforidlesessiontimeout.Whichoptionhasthecorrectfunctionalitieslistedforabackgroundprocess（）A.ArchiverProcess（ARCn）：1，2，5B.SystemMonitorProcess（SMON）：1，4，5C.ProcessMonitorProcess（PMON）：4，5，6D.DatabaseWriterProcess（DBWn）：1，3，4
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）A、2, 4, 3B、1, 4, 3, 2C、2, 5, 4, 3, 6D、5, 2, 4, 3, 6E、1, 5, 4, 3, 6, 2
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
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）A、On startup， SMON coordinates instance recovery.B、On startup， CKPT coordinates instance recovery.C、On startup， use RMAN to perform instance recovery.D、Uncommitted changes will be rolled back after the database is opened.E、On startup， perform media recovery and then instance recovery.F、On startup， all the files will be synchronized and you get both committed and uncommitted data.
You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database： 1：SGA is allocated. 2：Control file is read. 3：Redo log files are read. 4：Instance recovery is started. 5：Background processes are started. 6：Data files are checked for consistency. 7：Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A、7，1，5，2，3，6，4B、1，2，3，7，5，6，4C、7，1，4，5，2，3，6D、1，7，5，4，2，3，6
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
You used the IMMEDIATE option to shut down your database instance. Consider the steps that mayoccur when a database instance is started and database is opened： 1：SGA is allocated. 2：Control file is read. 3：Redo log files are opened. 4：Instance recovery is started. 5：Background processes are started. 6：Data file headers are checked for consistency. 7：Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A、7，1，5，2，3，6，4B、1，5，7，2，3，6；step 4 is not requiredC、7，1，5，2，3，6；step 4 is not requiredD、1，2，3，5，6，4；step 7 is not required
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 points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem. Which point describes the Oracle Data Pump utility（）A、1B、2C、3D、4E、1 and 3F、1， 2， 3， and 4
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.
ORACLE数据库启动后，有哪五个必要的后台进程（mandatory background processes）（）A、CKPT DBWn LGWR PMON SMONB、ARCn CKPT DBWn LGWR SMONC、CJQ0 CKPT DBWn LGWR SMOND、DBWn LGWR PMON RECO SMONE、CKPT DBWn LMON PMON SMON
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A、7， 1， 5， 2， 3， 6， 4B、1， 2， 3，7， 5， 6， 4C、7， 1， 4， 5， 2， 3， 6D、1， 7， 5， 4， 2， 3， 6
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
You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A、7， 1， 5， 2， 3， 6， 4B、1， 5， 7， 2， 3， 6； step 4 is not requiredC、7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from = http：//www.amaderforum.comD、1， 2， 3， 5， 6， 4； step 7 is not required
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
单选题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 points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem. Which point describes the Oracle Data Pump utility（）A1B2C3D4E1 and 3F1， 2， 3， and 4
单选题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
单选题ORACLE数据库启动后，有哪五个必要的后台进程（mandatory background processes）（）ACKPT DBWn LGWR PMON SMONBARCn CKPT DBWn LGWR SMONCCJQ0 CKPT DBWn LGWR SMONDDBWn LGWR PMON RECO SMONECKPT DBWn LMON PMON SMON
多选题You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）AOn startup， SMON coordinates instance recovery.BOn startup， CKPT coordinates instance recovery.COn startup， use RMAN to perform instance recovery.DUncommitted changes will be rolled back after the database is opened.EOn startup， perform media recovery and then instance recovery.FOn startup， all the files will be synchronized and you get both committed and uncommitted data.
单选题You used the IMMEDIATE option to shut down your database instance. Consider the steps that mayoccur when a database instance is started and database is opened： 1：SGA is allocated. 2：Control file is read. 3：Redo log files are opened. 4：Instance recovery is started. 5：Background processes are started. 6：Data file headers are checked for consistency. 7：Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A7，1，5，2，3，6，4B1，5，7，2，3，6；step 4 is not requiredC7，1，5，2，3，6；step 4 is not requiredD1，2，3，5，6，4；step 7 is not required
单选题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
单选题You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen a database instance is started and database is opened： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are opened.4. Instance recovery is started. 5. Background processes are started. 6. Data file headers are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A7， 1， 5， 2， 3， 6， 4B1， 5， 7， 2， 3， 6； step 4 is not requiredC7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from = http：//www.amaderforum.comD1， 2， 3， 5， 6， 4； step 7 is not required
单选题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
单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database： 1：SGA is allocated. 2：Control file is read. 3：Redo log files are read. 4：Instance recovery is started. 5：Background processes are started. 6：Data files are checked for consistency. 7：Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A7，1，5，2，3，6，4B1，2，3，7，5，6，4C7，1，4，5，2，3，6D1，7，5，4，2，3，6