Microsoft
98-361 · Question #31
A table named Student has columns named ID, Name, and Age. An index has been created on the ID column. What advantage does this index provide?
Sign in or unlock 98-361 to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.
Understanding Databases
Question
A table named Student has columns named ID, Name, and Age. An index has been created on the ID column. What advantage does this index provide?
Options
- AIt reorders the records alphabetically.
- BIt speeds up query execution.
- CIt minimizes storage requirements.
- DIt reorders the records numerically.
Unlock 98-361 to see the answer
You've previewed enough free 98-361 questions. Unlock 98-361 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#database index#query performance#query optimization