Which of the Following Is True About Indexes and Index

question 17

Multiple Choice

Which of the following is true about indexes and index fragmentation?

• A)indexes do not have to be updated once they are created
• B)records should be stored on the disk contiguously
• C)database records stored in order are said to be fragmented
• D)external fragmentation occurs due to accumulation of free space between records

---

Definitions:

Arousal

A state of physiological and psychological alertness or excitement, varying in intensity and triggered by different stimuli.

Genital Arousal

The physiological response of the genital organs to sexual stimulation, leading to an increase in blood flow and erection in males or lubrication and swelling in females.

Homosexuality

Romantic or sexual attraction to people of one's own sex.

Excitation Transfer

A psychological process where arousal from one situation intensifies the reaction to a subsequent, unrelated event.