Logical Database Design
Q. What is concurrency control in a DBMS?
-
A.
Managing data redundancy
-
B.
Ensuring data consistency during simultaneous access
-
C.
Optimizing query performance
-
D.
Backing up data
Solution
Concurrency control in a DBMS ensures data consistency during simultaneous access by multiple transactions.
Correct Answer: B — Ensuring data consistency during simultaneous access
Q. What is the main goal of normalization?
-
A.
To increase data redundancy
-
B.
To eliminate data anomalies
-
C.
To improve query performance
-
D.
To simplify database design
Solution
The main goal of normalization is to eliminate data anomalies and ensure data integrity by organizing data efficiently.
Correct Answer: B — To eliminate data anomalies
Showing 1 to 2 of 2 (1 Pages)
