053-387

转载于 2017-11-13 16:47:00 发布 · 60 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Babylon/p/7827003.html

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.

　　FLASHBACK_TRANSACTION_QUERY is the correct view to query,and it can be done using either timestamps or SCN ranges.DBA_TRANSACTION_QUERY is not a valid view;therefore options A and D are incorrect.

　　START_SCN 和 START_TIMESTAMP 都是指一个时间点

转载于:https://www.cnblogs.com/Babylon/p/7827003.html