If you use the BEGIN TRANSACTION statement, then execute 2 insert statements and 2 delete
statements what will happen if you execute ROLLBACK TRANSACTION?

A.
Only the INSERT statements will be rolled back

B.
All of the INSERTS and DELETES will be rolled back

C.
Only the last INSERT and last DELETE statement will be rolled back

D.
Only the DELETE statements will be rolled back

Explanation:
BEGIN TRANSACTION represents a point at which the data referenced by a connection is logically
and physically consistent. All modifications are erased when you issue a ROLLBACK
TRANSACTION statement.