The SQL statements executed in a user session are as follows:

Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)

Question

The SQL statements executed in a user session are as follows: Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)

Accepted Answer

A. The rollback generates an error. B. No SQL statements are rolled back.

Answer

C. Only the DELETE statements are rolled back.

Answer

D. Only the second DELETE statement is rolled back.

Answer

E. Both the DELETE statements and the UPDATE statement are rolled back.

The SQL statements executed in a user session are as follows: Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)

Question

Exhibit

Options

How the community answered

Community Discussion