Multiple choice

In OLTP, normalisation of database is done to

  1. make the operational data dynamic

  2. facilitate insertion, deletion and updation of data

  3. store the data at microscopic level

  4. reduce the response time of the system

  5. facilitate queries and analysis

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

OLTP stands for 'on line transaction processing'. In it, normalisation of database is done to facilitate insertion, deletion and updation of data.