Multiple choice

The main advantage of normalized relations in relational DBMS is that they

  1. are highly secure

  2. do not suffer from anomalies during delete and update operations

  3. occupy minimal storage

  4. all of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The primary goal of normalization is to reduce data redundancy, which in turn prevents update, insertion, and deletion anomalies.

Keep practicing — related questions