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

题目

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.
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Which two statements regarding the Flashback Table feature are correct?()

A. Flashback Table can be performed on system tables.

B. Flashback Table operation does not shrink the segments.

C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.

D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.


参考答案:B, D

第2题:

You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct?()

  • A、The FLASHBACK TABLE statement will not be written to the alert log file.
  • B、The changes made to the EMP table since the specified time will be undone.
  • C、The EMP table that was dropped by mistake from the database will be restored.
  • D、The FLASHBACK TABLE statement will be executed within a single transaction.
  • E、The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. 
  • F、The list of transactions that have modified the EMP table since the specified time will be displayed.

正确答案:B,D

第3题:

Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;Which of these statements will be dependent on the availability of relevant undo data in the undo segment?()

A. 1, 2, and 5

B. 1, 3, and 4

C. 2, 3, 4, and 5

D. 1, 2, 3, 4, and 5


参考答案:A

第4题:

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 EMPLOYEES table. 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 recovery
  • B、perform a Flashback Table operation to restore the table to the state it was in two days ago
  • C、perform a Flashback Database operation to restore the database to the state it was in two days ago
  • D、perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery

正确答案:D

第5题:

Over the course of a day,a department performed multiple DML statements (inserts, updates, deletes) on multiple rows of data in multiple tables. The manager would like a report showing the time, table name,and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list?()

  • A、 Flashback Drop
  • B、 Flashback Query
  • C、 Flashback Transaction Query
  • D、 Flashback Versions Query
  • E、 Flashback Table

正确答案:C

第6题:

By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify:  a) a list of changes made along with the transaction identifier of each change  b) the necessary SQL statements to undo the erroneous changes  Which option would you choose?()

  • A、RMAN only
  • B、Flashback Table only
  • C、Flashback Versions Query only
  • D、Flashback Database and Flashback Transaction Query
  • E、Flashback Versions Query and Flashback Transaction Query

正确答案:E

第7题:

Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()

  • A、Because row IDs may change during the flashback operation
  • B、Because the object number changes after the flashback operation
  • C、Because the rows are retrieved from the recycle bin during the flashback operation
  • D、Because the table is moved forward and back to a temporary during the flashback opertion

正确答案:A

第8题:

Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?()

A. Because row IDs may change during the flashback operation

B. Because the object number changes after the flashback operation

C. Because the rows are retrieved from the recycle bin during the flashback operation

D. Because the table is moved forward and back to a temporary during the flashback opertion


参考答案:A

第9题:

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command. Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()

  • A、Restore the backup control file and open the database with RESETLOGS option.
  • B、Perform point-in-time recovery because flashback cannot be performed again on this table
  • C、Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
  • D、Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

正确答案:D

第10题:

Why would you use the following FLASHBACK TABLE command?()  FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); 

  • A、to undo the changes made to the EMP table since the specified time
  • B、to restore the EMP table that was wrongly dropped from the database
  • C、to view the transactions that have modified the EMP table since the specified time
  • D、to view the changes made to the EMP table for one or more rows since the specified time
  • E、to recover the EMP table to a point in time in the past by restoring the most recent backup

正确答案:A

更多相关问题