What does the letter 'D' stand for in the widely accepted ACID properties of database transactions? MCQ with Answer and Explanation

What does the letter 'D' stand for in the widely accepted ACID properties of database transactions?
A. Durability
B. Dependency
C. Definition
D. Data
Answer: Option A
Solution (By JKSSB Mock Tests)
ACID stands for Atomicity, Consistency, Isolation, and Durability. Durability ensures that once a transaction commits, its changes survive system failures.

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 meaning of the term 'redundancy' in databases?
A. Inconsistent data
B. Duplicate storage of the same data
C. Data in multiple tables
D. Lack of data

Correct Answer: Option B


Explanation:
Redundancy refers to the unnecessary duplication of data, which can lead to anomalies and wasted storage.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is normalization in database design?
A. The process of organizing data to reduce redundancy and improve integrity
B. The process of indexing tables
C. The process of encrypting data
D. The process of increasing data duplication

Correct Answer: Option A


Explanation:
Normalization is the process of structuring a relational database to reduce data redundancy and dependency, typically by dividing large tables into smaller, related tables.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What is a subquery in database terminology?
A. A query that runs on a backup server.
B. An error log file.
C. A nested SQL query placed completely inside another outer query statement.
D. A query that executes after the main query terminates.

Correct Answer: Option C


Explanation:
A subquery (or nested query) is an inner SQL SELECT statement embedded within an outer statement (such as a WHERE, FROM, or SELECT clause).

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