What does the ROLLBACK statement do? MCQ with Answer and Explanation

Question

Share Report Error

What does the ROLLBACK statement do?

A. Saves the changes

B. Undoes all changes made in the current transaction

C. Starts a new transaction

D. Creates a savepoint

Answer: Option B

Solution (By JKSSB Mock Tests)

ROLLBACK reverts the database to the state it was in at the beginning of the transaction, undoing all changes.

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

What is the purpose of the SQL 'CHECK' constraint?

A. To define relationships

B. To validate data based on a condition

C. To set a default value

D. To enforce uniqueness

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
CHECK constraint ensures that values in a column meet a specified condition, such as age > 0.

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

Question #2

The range of all permissible and valid values that an attribute can hold is formally defined as its what?

A. Schema

B. Tuple

C. Domain

D. Relation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Domain is the pool of legal, atomic values from which an attribute can take its value.

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

Question #3

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

A. Tables

B. Graphs

C. Flat text files

D. Trees

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

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)

Explore All Database Management System (DBMS) MCQs