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
Correct Answer:
Verified
Correct Answer:
Verified
Q12: Which of the following would you use
Q13: Which problem occurs when a concurrent process
Q14: _ indexes and indexed views should be
Q15: Why is the selection of data types
Q16: Which situation occurs when two transactions each
Q18: What happens to a request for a
Q19: Which of the following is NOT a
Q20: Which component of the SQL Server database
Q21: List and describe three types of problems
Q22: If a request is made to use