Your CUSTOMER_ORDER and ORDERJTEMS table is updated daily with both phone orders and Internet orders. During an ad-hoc maintenance operation, an operations specialist accidentally deletes several items from an order placed last week. Which flashback feature will minimize the loss of recent updates to the ORDERJTEMS table and easily retrieve the missing rows? (Choose the best answer.)

Answer: C

Explanation: You can use INSERT INTO . . . SELECT . . . AS OF to retrieve the lost rows, specifying a timestamp value right before the accidental deletion. A is incorrect because Flashback Data Archive makes it easier to retain historical data but does not directly retrieve the missing rows. B is incorrect because even though Flashback Versions Query makes it easy to see versions of a row within a specific time period, you will have to perform additional steps to insert the missing data. D is incorrect because you can access all the changes made for a given transaction, but you need to know the transaction ID and still have to insert the missing rows. E is incorrect because even though Flashback Table will rewind the table to a point in time before the rows were deleted, you will lose all recent transactions to the table.