Sql transaction what can come after

Question

Can you please tell me why c and d are the right answers here ? Thank you

Select the statements that can be used to complete the following SQL code block

BEGIN TRANSACTION
SELECT COUNT(*) FROM Enrollments WHERE Accepted = 1
UPDATE Enrollments SET Accepted = 1 WHERE CourseTitle = ’Data Base’

(a) END TRANSACTION (b) END (c) COMMIT (d) ROLLBACK TRANSACTION

Answer 1

Because those are the SQL key words that can be used to end a transaction

COMMIT will submit your transaction and end it.

While ROLLBACK will, as its name suggests roll the database back to how it was before the transaction was started.