ocp 053 oracle,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答案完全一样.