Which SQL command is used to reverse or undo all modifications made during the current transaction that have not yet been committed? MCQ with Answer and Explanation

Question

Which SQL command is used to reverse or undo all modifications made during the current transaction that have not yet been committed?

A. SAVEPOINT

B. REVERT

C. ROLLBACK

D. UNDO

Answer: Option C

Solution (By JKSSB Mock Tests)

The ROLLBACK command is a TCL statement used to undo transactions, restoring the database to its last committed or safe state.

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

Which SQL clause is used to limit the number of rows returned in a query?

A. All of the above (depending on DBMS)

B. TOP

C. ROWNUM

D. LIMIT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Different DBMS use different keywords: MySQL uses LIMIT, SQL Server uses TOP, Oracle uses ROWNUM.

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

Question #2

Share Report

Which SQL statement is used to retrieve data from a database?

A. UPDATE

B. SELECT

C. INSERT

D. DELETE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SELECT is the SQL command used to query and retrieve data from one or more tables.

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

Question #3

Share Report

In SQL, which clause is used to specify the table(s) from which to retrieve data?

A. FROM

B. GROUP BY

C. WHERE

D. SELECT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The FROM clause identifies the table(s) from which data is to be selected.

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

Explore All Database Management System (DBMS) MCQs