What does ACID stand for in database transactions? MCQ with Answer and Explanation

Question

Share Report Error

What does ACID stand for in database transactions?

A. Accuracy, Control, Integrity, Data

B. Atomicity, Consistency, Isolation, Durability

C. All Correct Information Display

D. Access, Create, Insert, Delete

Answer: Option B

Solution (By JKSSB Mock Tests)

ACID properties ensure reliable transaction processing in DBMS.

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 of the following commands is a part of Transaction Control Language (TCL) in SQL?

A. GRANT

B. ALTER

C. COMMIT

D. DELETE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
COMMIT is a TCL command used to permanently save all modifications made during the current transaction into the database.

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

Question #2

Share Report

Which of the following is a collection of related data that is stored in a structured format?

A. Database

B. Data warehouse

C. Information

D. DBMS

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A database is an organized collection of related data, typically stored electronically and accessed through a DBMS.

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

Question #3

Share Report

What is the situation called when two or more transactions are permanently blocked, each waiting for a lock held by the other transaction to be released?

A. Deadlock

B. Concurrency

C. Isolation failure

D. Starvation

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Deadlock occurs when two or more transactions are stuck in a circular dependency, each waiting for resources locked by the other, preventing progress.

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

Explore All Database Management System (DBMS) MCQs