By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify:

(a) list of changes made along with the transaction identifier of each change. (b) The necessary SQL statements to undo the erroneous changes. Which option would you choose?

Question

By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify:

(a) list of changes made along with the transaction identifier of each change. (b) The necessary SQL statements to undo the erroneous changes. Which option would you choose?

Accepted Answer

E. Flashback Version Query and Flashback Transaction Query.

Answer

A. RMAN only.

Answer

B. Flashback Table only.

Answer

C. Flashback Version Query only.

Answer

D. Flashback Database and Flashback Transaction Query.

By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: (a) list of changes made…

Question

Options

How the community answered

Community Discussion