单选题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

考题 Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）A. Redo logsB. Control fileC. The latest backup of only the damaged data fileD. The latest backup of all the data file in the USERS tablespaceE. Temporary files of temporary tablespaceF. Archive Logs since the latest backup to point of failure

查看答案

考题 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 is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）A、Redo logsB、Control fileC、The latest backup of only the damaged data fileD、The latest backup of all the data file in the USERS tablespaceE、Temporary files of temporary tablespaceF、Archive Logs since the latest backup to point of failure

查看答案

考题 Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)A、Redo logsB、Control fileC、The latest backup of only the damaged data fileD、The latest backup of all the data file in the USERS tablespaceE、Temporary files of temporary tablespaceF、Archive Logs since the latest backup to point of failure

查看答案

考题 Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） A、 redo logsB、 control fileC、 temporary files of temporary tablespaceD、 the latest backup of only the damaged data fileE、 the latest backup of all the data files In the USERS tablespace

查看答案

考题 Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）A、 open the database with the RESTRICTED optionB、 open the database with the RESETLOGS optionC、 recover to the required SCN only that data file in which the error occurredD、 recover all the data files to the same system change number （SCN）

查看答案

考题 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

查看答案

考题 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

查看答案

考题 Case 1： 1. Shut down the database and perform a backup. 2. Restore all the data files. 3. Mount the database. 4. Recover the database. 5. Without applying all the redo log files， open the database using the RESETLOGS option. 6. Back up the database. Case 2： 1. Shut down the database and perform a backup. 2. Restore only the data files of the tablespace where user error damaged the data. 3. Mount the database. 4. Recover the database. 5. Open the database with the RESETLOGS option. 6. Back up the database. Case 3： 1. Shut down the database. 2. Restore the data files. 3. Open the database. 4. Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）A、 Only case 1B、 Only case 2C、 Only case 3D、 Case 1 and 2E、 Case 2 and 3F、 Case 1 and 3G、 All cases， case 1， case 2， case 3

查看答案

考题 An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace： 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen？（）A、Recovery ManagerB、Recovery WindowC、Recovery WizardD、Enterprise Manager Home Page

查看答案

考题 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. 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

查看答案

考题单选题Case 1： 1. Shut down the database and perform a backup. 2. Restore all the data files. 3. Mount the database. 4. Recover the database. 5. Without applying all the redo log files， open the database using the RESETLOGS option. 6. Back up the database. Case 2： 1. Shut down the database and perform a backup. 2. Restore only the data files of the tablespace where user error damaged the data. 3. Mount the database. 4. Recover the database. 5. Open the database with the RESETLOGS option. 6. Back up the database. Case 3： 1. Shut down the database. 2. Restore the data files. 3. Open the database. 4. Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）A Only case 1B Only case 2C Only case 3D Case 1 and 2E Case 2 and 3F Case 1 and 3G All cases， case 1， case 2， case 3

查看答案

考题单选题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

查看答案

考题单选题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

查看答案

考题单选题The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery（）A Inactive and current redo log files are required to accomplish recovery.B Online and archived redo log files are required to accomplish instance recovery.C All redo log entries after the last checkpoint are applied from redo log files to data files.D All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files

查看答案

考题单选题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

查看答案

考题单选题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 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

查看答案

考题单选题An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace： 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen？（）A Recovery ManagerB Recovery WindowC Recovery WizardD Enterprise Manager Home Page

查看答案

考题单选题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

查看答案

考题单选题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

查看答案

考题多选题Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）ARedo logsBControl fileCThe latest backup of only the damaged data fileDThe latest backup of all the data file in the USERS tablespaceETemporary files of temporary tablespaceFArchive Logs since the latest backup to point of failure

查看答案

考题单选题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

查看答案

考题多选题Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available. Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（）Aredo logsBcontrol fileCtemporary files of temporary tablespaceDthe latest backup of only the damaged data fileEthe latest backup of all the data files In the USERS tablespace

查看答案

考题单选题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

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：