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

Counterintuitively, introducing controlled redundancy (denormalization) often improves SQL performance by reducing joins and table scans. Removal of redundancy (A) is normalization, which can hurt performance. Non-first normal form (C) relates to complex values, not performance. SQL*Plus (D) is an Oracle tool, irrelevant to performance.

Keep practicing — related questions