Which of the following is true about indexes and index fragm

Which of the following is true about indexes and index fragmentation? a. database records stored in order are said to be fragmented b. records should be stored on the disk contiguously c. indexes do not have to be updated once they are created d. external fragmentation occurs due to accumulation of free space between records

Solution

Answer c: Indexes do not have to be updated once they are created.

Once we created the index on a particular column, we dont need to update them again. Once created, it will be there forever unless we altere or delete that index through manual intervention.