多选题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 transac

题目

多选题

Which two statements about Flashback Query are true？（）

It is generated by using the redo log files.

It helps in row-level recovery from user errors.

It can be performed to recover ALTER TABLE statements

It fails when undo data pertaining to the transaction is overwritten.

The database has to be opened with the resetlogs option after performing Flashback Query.

更多“多选题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 transac”相关问题

第1题

These are the details about V$FLASHBACK_DATABASE_STAT： SQL> DESC v$FLASHBACK_DATABASE_STAT Name Null？ Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME DATE FLASHBACK_DATA NUMBER DB_DATA NUMBER REDO_DATA NUMBER ESTIMATED_FLASHBACK_SIZE NUMBER Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue？（）A、 BEGIN_TIME is the time at which Flashback logging is enabled.B、 END_TIME is the time at which the query is executed on the view.C、 REDO_DATA is the number of bytes of redo data written during the interval.D、 This view contains information about flashback data pertaining to the last 24 hours.E、 FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

点击查看答案
第2题

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.

点击查看答案
第3题

You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）A、 restore the tablespace from the backup； there is no need to apply the redo informationB、 restore the full database to recover the data up to the point when you performed the backupC、 restore the tablespace from the backup and then perform a recovery using the backup control fileD、 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied

点击查看答案
第4题

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

点击查看答案
第5题

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.

点击查看答案
第6题

Which of the following statements is true regarding implementing a Flashback Table recovery？（）A、 An SCN is never used to perform a Flashback Table recovery.B、 If a significant number of changes have been made to the table， row movement must be enabled.C、 The tablespace must be offline before performing a Flashback Table recovery.D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.

点击查看答案
第7题

单选题Which of the following statements is true regarding implementing a Flashback Table recovery？（）AAn SCN is never used to perform a Flashback Table recovery.BIf a significant number of changes have been made to the table， row movement must be enabled.CThe tablespace must be offline before performing a Flashback Table recovery.DFlashback Table recovery is completely dependent on the availability of undo data in the undo tablespace.

点击查看答案

多选题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 transac

题目

更多“多选题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 transac”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容