Oracle OCP 1Z0 053 Q387(FLASHBACK_TRANSACTION_QUERY)

387.Which method could be utilized to identify both DML operations and the SQL statements needed to
undo those operations for a specific schema owner? (Choose all that apply.)
A. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows
by START_SCN and TABLE_OWNER.
B. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.
Limit rows by START_SCN and TABLE_OWNER.
C. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.
Limit rows by START_TIMESTAMP and TABLE_OWNER.
D. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows
by START_SCN and TABLE_OWNER.
Answer: BC


注意可以通過檢視flashback_transaction_query，並指定SCN或者時間戳來檢索DML歷史

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