What is the purpose of the COMMIT statement in SQL? MCQ with Answer and Explanation

Question

Share Report Error

What is the purpose of the COMMIT statement in SQL?

A. To permanently save all changes made in a transaction

B. To save a point within a transaction

C. To undo all changes made in a transaction

D. To start a new transaction

Answer: Option A

Solution (By JKSSB Mock Tests)

COMMIT finalizes a transaction, making all changes permanent in the database.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

In a Relational Database Management System (RDBMS), data is logically organized and stored in which form?

A. Graphs

B. Tables

C. Trees

D. Flat text files

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
In an RDBMS, data is organized into relations, which are logically represented as two-dimensional tables consisting of rows and columns.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Share Report

Which type of database storage anomaly occurs when adding new data to a table is blocked because other unrelated data is missing?

A. Deletion Anomaly

B. Modification Anomaly

C. Insertion Anomaly

D. Update Anomaly

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
An Insertion Anomaly occurs when certain facts cannot be recorded in a database table without falsely manufacturing or requiring the presence of other unrelated facts.

This question belongs to: Computer Database Management System (DBMS)