网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 forward
B
Uses Flashback Log for recovery
C
Uses online redo logs to roll back
D
Uses undo data to roll back the transaction
E
Uses Recovery Manager （RMAN） to roll back
F
Uses the System Monitor （SMON） background process to perform instance recovery
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.
考题
You work as a database administrator for Supportcenter.cn. 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. 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 can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）A、Oracle Flashback uses undo information to construct consistent data. B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session.
考题
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A、Restore all the data files and open the databaseB、Create the data file and performtablespacerecoveryC、No need to restore any file， just recover the databaseD、Restore only the system data file and recover the databaseE、Restore only lost date file and performtablespacerecovery
考题
Which three statements are true about Flashback Database?（）A、Flashback logs are written sequentially, and are archived.B、Flashback Database uses a restored control file to recover a database.C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.D、Flashback Database can recover a database to the state that it was in before a reset logs operation.E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
考题
You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）A、Increase the undo returnB、Create more undo segmentsC、Create another undotablespaceD、Increase the size of the undotablespace
考题
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.
考题
You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）A、Event Viewer gives more details on the failure.B、The alert log file gives detailed information about the failure.C、PMON rolls back the transaction and releases the locks.D、SMON rolls back the transaction and releases the locks.E、The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.F、Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
考题
You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）A、 perform point-in-time recoveryB、 perform a Flashback Table operation to restore the table to the state it was in two days agoC、 perform a Flashback Database operation to restore the database to the state it was in two days agoD、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
考题
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the tableB、 restore the entire database from the most recent backup and open itC、 recover the table by using the Flashback Table featureD、 perform point-in-time recovery to recover the table
考题
单选题You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）A
Increase the undo returnB
Create more undo segmentsC
Create another undotablespaceD
Increase the size of the undotablespace
考题
多选题Which three statements are true about Flashback Database?（）AFlashback logs are written sequentially, and are archived.BFlashback Database uses a restored control file to recover a database.CThe Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.DFlashback Database can recover a database to the state that it was in before a reset logs operation.EFlashback Database can recover a data file that was dropped during the span of time of the flashback.FFlashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
考题
单选题You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）A
perform point-in-time recoveryB
perform a Flashback Table operation to restore the table to the state it was in two days agoC
perform a Flashback Database operation to restore the database to the state it was in two days agoD
perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery
考题
单选题You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）A
use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the tableB
restore the entire database from the most recent backup and open itC
recover the table by using the Flashback Table featureD
perform point-in-time recovery to recover the table
考题
单选题You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do？（）A
Decrease the amount of time between transaction log backups.B
Configure the database to use the simple recovery model.C
Configure the RECOVERY INTERVAL option to be a smaller value.D
Run DBCC SHRINKFILE on the transaction log file.
考题
多选题You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， Certkiller， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）AUse a flashback query to retrieve the rows that were deletedBUseconventialincremental export and then import the affected objectCShutdown the database inNORMALmode and restart the database instanceDUse DBMS_META package to reconstruct the object using undo segmentsEUseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the dataFUse Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
考题
多选题You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， SupportCenter， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）AUse a flashback query to retrieve the rows that were deletedBUseconventialincremental export and then import the affected objectCShutdown the database inNORMALmode and restart the database instanceDUse DBMS_META package to reconstruct the object using undo segmentsEUseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the dataFUse Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
考题
单选题You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）A
You performed rollback after commit.B
If a log switch occurs in your database.C
Thearchiverfails to generate an archived log file.D
Instance recovery fails to find one of the redo log files.E
A long-running query is unable to get read-consistent image.F
If you perform manual undo management operations in auto mode.
考题
单选题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. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）A
Restore all the data files and open the databaseB
Create the data file and performtablespacerecoveryC
No need to restore any file， just recover the databaseD
Restore only the system data file and recover the databaseE
Restore only lost date file and performtablespacerecovery
考题
单选题You work as a database administrator for Supportcenter.cn. 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. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）AEvent Viewer gives more details on the failure.BThe alert log file gives detailed information about the failure.CPMON rolls back the transaction and releases the locks.DSMON rolls back the transaction and releases the locks.EThe transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.FData modified by the transaction up to the last commit before the abnormal termination is retained in the database.
考题
单选题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.
考题
多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.
考题
单选题On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?（）A
Check the alert log fileB
Query the V$FLASHBACK_DATABASE_LOG viewC
Query the V$RECOVERY_FILE_DEST_SIZE viewD
Query the V$FLASHBACK_DATABASE_STAT viewE
Check the value assigned for the UNDO_RETENTION parameter
考题
单选题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
热门标签
最新试卷
