（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答案完全一样.

ITPub博客

Oracle 11G OCP 1Z0-053 387

最新文章