Question 18Asked in DSSSB TGT Computer Science (Technical), 12 Sep 2025, Shift 3 (5:00 PM)

What is the purpose of the COMMIT command in SQL?

  1. ATo create a new table
  2. BTo assign privileges
  3. CTo rollback the changes
  4. DTo permanently save changes made in a transaction
Show answerHide answer

Correct answer: (D) To permanently save changes made in a transaction

Explanation

COMMIT ends a transaction and makes all its changes permanent in the database. ROLLBACK is the command that undoes them.

From DSSSB TGT Computer Science PYQ (Technical), 12 Sep 2025, Shift 3 (5:00 PM)

This is question 18 of DSSSB TGT Computer Science PYQ (Technical), 12 Sep 2025, Shift 3 (5:00 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.