Oracle 1Z0 053 Q666(Flashback Table)
666.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
Answer: D
簡單的再做一次FLASHBACK TABLE, 而不需point-in-time tablespace recovery
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
Answer: D
簡單的再做一次FLASHBACK TABLE, 而不需point-in-time tablespace recovery
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2074511/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0 053 Q373(Flashback Table)Oracle
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0 053 Q83(Flashback Database)OracleDatabase
- Oracle OCP 1Z0 053 Q138(DROP FLASHBACK ARCHIVE)OracleHive
- Oracle OCP 1Z0 053 Q704(Flashback Versions Query)Oracle
- Oracle OCP 1Z0 053 Q130(flashback transactions)Oracle
- Oracle OCP 1Z0 053 Q143(Flashback Data Archive)OracleHive
- Oracle OCP 1Z0 053 Q387(FLASHBACK_TRANSACTION_QUERY)Oracle
- Oracle OCP 1Z0 053 Q63(flashback_transaction_query)Oracle
- Oracle OCP 1Z0 053 Q677(Flashback Transaction Query)Oracle
- Oracle OCP 1Z0-053 Q686(Flashback Table)Oracle
- Oracle OCP 1Z0-053 Q385(Flashback Table Recovery)Oracle
- Oracle OCP 1Z0 053 Q105(Table Compression)Oracle
- Oracle OCP 1Z0 053 Q43(Flashback Transaction(NOCASCADE_FORCE))Oracle
- Oracle OCP 1Z0 053 Q390(Flashback database&Named restore point)OracleDatabaseREST
- oracle flashback特性(2.1)--Flashback Table之RECYCLEBINOracle
- 應用oracle flashback--Flashback Table之RECYCLEBINOracle
- 【徵文】應用oracle flashback(2.1)--Flashback Table之RECYCLEBINOracle
- 全面學習oracle flashback特性(2.1)--Flashback Table之RECYCLEBINOracle
- oracle flashback特性(2.2)--Flashback Table之從UNDO中恢復Oracle
- 【徵文】應用oracle flashback(2.3)--Flashback Table之注意事項Oracle
- 【Flashback】Flashback Table功能實踐
- flashback技術之---flashback table
- 全面學習oracle flashback特性(2.3)--Flashback Table之注意事項Oracle
- Oracle OCP 1Z0 053 Q650Oracle
- Oracle OCP 1Z0 053 Q324Oracle
- Oracle OCP 1Z0 053 Q27Oracle
- Oracle OCP 1Z0 053 Q49Oracle
- Oracle OCP 1Z0 053 Q10Oracle
- Oracle OCP 1Z0 053 Q685Oracle
- Oracle OCP 1Z0 053 Q454Oracle
- Oracle OCP 1Z0 053 Q500Oracle
- 【徵文】應用oracle flashback(2.2)--Flashback Table之從UNDO中恢復Oracle
- Oracle OCP 1Z0 053 Q517(Block Media Recovery&Archivelog Mode&Flashback Logging)OracleBloCHive
- Oracle OCP 1Z0 053 Q444(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q440(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q601Oracle
- Oracle OCP 1Z0 053 Q472(Locale)Oracle