Oracle 11G OCP 1Z0-053 387

(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.

答案:(B、C)

解析:

根本没有DBA_TRANSACTION_QUERY这个视图, A, D答案完全一样.

请使用浏览器的分享功能分享到微信等