What is the purpose of the SAVEPOINT statement? MCQ with Answer and Explanation

Question

Share Report Error

What is the purpose of the SAVEPOINT statement?

A. To start a new transaction

B. To create a point within a transaction to which you can later roll back

C. To release locks

D. To permanently save changes

Answer: Option B

Solution (By JKSSB Mock Tests)

SAVEPOINT creates a named point within a transaction, allowing partial rollback to that point without affecting the entire transaction.

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

The command to modify existing records in a table is:

A. UPDATE

B. CHANGE

C. MODIFY

D. ALTER

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
UPDATE is the DML command used to modify data in existing rows.

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

Question #2

In SQL, how do you check if a value is NOT NULL?

A. NOT NULL

B. != NULL

C. IS NULL

D. IS NOT NULL

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
IS NOT NULL is the correct operator to test for non-NULL values.

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

Question #3

Which of the following is a DML statement?

A. DROP

B. ALTER

C. CREATE

D. UPDATE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
UPDATE is a Data Manipulation Language (DML) command used to modify existing records in a table. CREATE, ALTER, DROP are DDL.

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

Explore All Database Management System (DBMS) MCQs