Multiple choice

Which of the following techniques is used for denormalisation in which the records are summarised in some summary columns and the number of records stored in a table is reduced?

  1. Vertical fragmentation

  2. Horizontal partitioning

  3. Summary data

  4. Duplicate data

  5. Functional dependency

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

This is the technique used for denormalisation in which the records are summarised in some summary columns. It reduces the number of records stored in a table.