Multiple choice technology databases

Which of the following database design features is most important to SQL performance?

  1. Removal of data redundancy

  2. The introduction of data redundancy

  3. The introduction of non-first normal form relations

  4. The introduction of SQL*Plus
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Introducing data redundancy (denormalization) is a key design feature used to optimize SQL performance in read-heavy applications. By replicating data, it reduces the need for expensive table joins. Although normal forms remove redundancy to protect data integrity, they can degrade query performance due to join overhead.

Keep practicing — related questions