RMAN only
Flashback Table only
Flashback Versions Query only
Flashback Database and Flashback Transaction Query
Flashback Versions Query and Flashback Transaction Query
第1题:
At the end of the financial year, an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process, some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process, but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11:50 P.M. Which flashback feature will you use?()
第2题:
You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP (’11:45’,’hh12:mi’); Which two statements are correct?()
第3题:
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
第4题:
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()
第5题:
Which two statements are correct regarding the Flashback Versions Query feature?()
第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?()
第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?()
第8题:
You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database. What should you do?()
第9题:
You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?()
第10题:
You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE 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 and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that: a) No other user data in the database is affected. b) The operation takes the minimum possible time. Which option would you choose?()