What kind of lock allows multiple concurrent transactions to read a database row simultaneously but blocks any transaction from writing to it? MCQ with Answer and Explanation

What kind of lock allows multiple concurrent transactions to read a database row simultaneously but blocks any transaction from writing to it?
A. Shared Lock
B. Deadlock
C. Exclusive Lock
D. Intent Lock
Answer: Option A
Solution (By JKSSB Mock Tests)
A Shared Lock (S-lock) permits concurrent transactions to read a resource but prevents any modification operations until the lock is released.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which of the following SQL commands belongs to the Data Definition Language (DDL) category?
A. SELECT
B. INSERT
C. UPDATE
D. CREATE

Correct Answer: Option D


Explanation:
The CREATE command is a DDL statement because it defines, modifies, or creates database structures like tables, schemas, or indexes.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which of the following is a characteristic of a DBMS?
A. Security and access control
B. All of the above
C. Data redundancy control
D. Data independence

Correct Answer: Option B


Explanation:
A DBMS provides features like data independence, reduced redundancy, security, and concurrent access.

This question belongs to: Computer Database Management System (DBMS)
Question #3
The concept that prevents concurrent transactions from interfering with each other and creating data inconsistencies is known as what?
A. Isolation
B. Consistency
C. Atomicity
D. Durability

Correct Answer: Option A


Explanation:
Isolation ensures that the execution of concurrent transactions does not interfere with one another, making them appear as if they are executing sequentially.

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