Managing Multiuser Databases
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
Show solution
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
Learn More →
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
Show solution
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
Learn More →
Q. Which of the following is NOT a property of transactions in the ACID model?
A.
Atomicity
B.
Consistency
C.
Isolation
D.
Durability
Show solution
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.
Correct Answer: D — Durability
Learn More →
Showing 1 to 3 of 3 (1 Pages)
