Which method could be utilized to identify both DML ope…

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

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_TIMESTAMP and TABLE_OWNER.



Leave a Reply 0

Your email address will not be published. Required fields are marked *