Multiple Choice
Which of the following is a suggested threshold for performing index fragmentation maintenance?
A) delete and recreate if the fragmentation is more than 10 percent
B) update statistics for fragmentation more than 30 percent
C) rebuild if the fragmentation is less than 5 percent
D) reorganize if the logical fragmentation is between 5 and 30 percent
Correct Answer:
Verified
Correct Answer:
Verified
Q31: _ improves the integrity of the database
Q32: Which counter measures the data being transferred
Q33: The % Processor Time performance counter displays
Q34: Only one user or client application at
Q35: Describe two SQL Server procedures that can
Q36: Index _ is a routine task that
Q38: What are the two types of system
Q39: Which of the following is NOT a
Q40: Which of the following is true about
Q41: Which of the following is a database