Q. In a multiuser database environment, what is a deadlock?
A.A situation where two transactions are waiting for each other to release locks
B.A method of data encryption
C.A type of database backup
D.A way to optimize queries
Solution
A deadlock occurs when two transactions are waiting for each other to release locks, preventing both from proceeding.
Correct Answer: A — A situation where two transactions are waiting for each other to release locks
Q. What is the primary purpose of normalization in a database?
A.To increase data redundancy
B.To eliminate data anomalies
C.To improve query performance
D.To simplify database design
Solution
Normalization is used to eliminate data anomalies and ensure data integrity by organizing data into related tables.
Correct Answer: B — To eliminate data anomalies
Q. Which of the following is NOT a property of transactions in the ACID model?
A.Atomicity
B.Consistency
C.Isolation
D.Durability
Solution
All options listed are properties of transactions in the ACID model; however, the question asks for the one that is NOT a property, which is incorrect.
