Oracle 11G OCP 1Z0-053 375

（375）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）

解析：

Advanced Application Developer's Guide第12章

Use Oracle Flashback Transaction Query to retrieve metadata and historical data for a given transaction or for all transactions in a given time interval.

Oracle Flashback Transaction Query queries the static data dictionary view FLASHBACK_TRANSACTION_QUERY

時間->START_TIMESTAMP

型別->OPERATION

表名->TABLE_NAME

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1284281/，如需轉載，請註明出處，否則將追究法律責任。