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
Correct Answer:
Verified
Q19: Which of the following would you use
Q20: Which Windows tool can provide the most
Q21: _ improves the integrity of the database
Q22: Which command takes corrective action on a
Q23: How does external fragmentation occur?
Q25: A(n)_ is always created for the primary
Q26: _ indexes and indexed views should be
Q27: Why is the selection of data types
Q28: Which of the following is true about
Q29: What are two major design factors that
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents