多选题Which two operations require undo data？（）Acommitting a transactionBrolling back a transactionCrecovering from failed transactionsDrecording a transaction to redo log filesErolling forward during instance recovery
多选题
Which two operations require undo data？（）
A
committing a transaction
B
rolling back a transaction
C
recovering from failed transactions
D
recording a transaction to redo log files
E
rolling forward during instance recovery
参考解析
解析：
暂无解析
相关考题：
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
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction
Which two operations require undo data？（）A、committing a transactionB、rolling back a transactionC、recovering from failed transactionsD、recording a transaction to redo log filesE、rolling forward during 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
In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）A、the V$LOG viewB、the V$DBFILE viewC、the V$LOGFILE viewD、the V$INSTANCE_RECOVERY viewE、Oracle Enterprise Manager Database Control
What advantage would you get if you increase the length of time during which the undo information would be stored in the database？（）A、roll back of large transactionsB、roll forward to redo a transactionC、data concurrency for large updatesD、read consistency for long-running transactions
Which three operations require undo data（）A、committing a transactionB、flashing back a transactionC、recovering a failed transactionD、running a read-consistent queryE、changing a tablespace status from READ ONLY to READ WRITE
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
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during 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 datafiles.
Which two statements about Flashback Query are true？（）A、It is generated by using the redo log files. B、It helps in row-level recovery from user errors.C、It can be performed to recover ALTER TABLE statements D、It fails when undo data pertaining to the transaction is overwritten.E、The database has to be opened with the resetlogs option after performing Flashback Query.
The loss of which two types of files may require a recovery with the RESETLOGS option？（）A、 control filesB、 password fileC、 archived log filesD、 system-critical data files for which all the redo entries are presentE、 non-system-critical data files for which all the redo entries are present
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？ （）A、Transactions are rolled back using redo log files.B、Transactions are rolled forward using redo log files.C、Transactions are rolled back using redo log files and archived log files.D、Transactions are rolled forward using redo log files and rolled back using redo log files.
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)A、Creating the control file for the duplicate databaseB、Restoring the target data files to the duplicate databaseC、Performing complete recovery using all available backupsD、Generating a new, unique DBID for the duplicate databaseE、Copying the online redo log files from the target database to the duplicate database
Which three statements are true about database recovery operations？（）A、Damaged or lost data files are restored from backups.B、Redo log file entries are used to roll forward the database.C、Undo segments are used to roll back any uncommitted transactions.D、Transactions that were active when the failure occurred are restarted.E、Transactions that were active when the failure occurred are automatically committed during the recover procedure.
Which operations require undo data（）A、Committing a transactionB、Flashing back a transactionC、Recovering a failed transactionD、Running a read-consistent queryE、Changing a tablespace status from READ ONLY to READ WRITE
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）A、 Creating the control file for the duplicate databaseB、 Restoring the target data files to the duplicate databaseC、 Performing complete recovery using all available backupsD、 Generating a new， unique DBID for the duplicate databaseE、 Copying the online redo log files from the target database to the duplicate database
多选题Which three operations require undo data（）Acommitting a transactionBflashing back a transactionCrecovering a failed transactionDrunning a read-consistent queryEchanging a tablespace status from READ ONLY to READ WRITE
单选题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 two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?（）ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming complete recovery using all available backupsDGenerating a new, unique DBID for the duplicate databaseECopying the online redo log files from the target database to the duplicate database
多选题The loss of which two types of files may require a recovery with the RESETLOGS option？（）Acontrol filesBpassword fileCarchived log filesDsystem-critical data files for which all the redo entries are presentEnon-system-critical data files for which all the redo entries are present
多选题Which operations require undo data（）ACommitting a transactionBFlashing back a transactionCRecovering a failed transactionDRunning a read-consistent queryEChanging a tablespace status from READ ONLY to READ WRITE
多选题Which three statements are true about database recovery operations？（）ADamaged or lost data files are restored from backups.BRedo log file entries are used to roll forward the database.CUndo segments are used to roll back any uncommitted transactions.DTransactions that were active when the failure occurred are restarted.ETransactions that were active when the failure occurred are automatically committed during the recover procedure.
多选题Which two statements about Flashback Query are true？（）AIt is generated by using the redo log files.BIt helps in row-level recovery from user errors.CIt can be performed to recover ALTER TABLE statementsDIt fails when undo data pertaining to the transaction is overwritten.EThe database has to be opened with the resetlogs option after performing Flashback Query.
多选题Which two operations require undo data？（）Acommitting a transactionBrolling back a transactionCrecovering from failed transactionsDrecording a transaction to redo log filesErolling forward during instance recovery
单选题You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）AThe online redo log files and archived redo log files are required to accomplish the recovery.BThe uncommitted transaction will be committed at the next startup of the database instance.CThe uncommitted transaction is rolled back automatically at the next opening of the database.DThe DBA has to perform the recovery on the database to recover the uncommitted transaction
多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming complete recovery using all available backupsDGenerating a new, unique DBID for the duplicate databaseECopying the online redo log files from the target database to the duplicate database
单选题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
多选题In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）Athe V$LOG viewBthe V$DBFILE viewCthe V$LOGFILE viewDthe V$INSTANCE_RECOVERY viewEOracle Enterprise Manager Database Control