Microsoft

98-361 · Question #146

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?

The correct answer is C. It speeds up query execution. Faster to access an index table.

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 reorders the records numerically.
CIt speeds up query execution.
DIt minimizes storage requirements.

How the community answered

(33 responses)

A
15% (5)
B
3% (1)
C
73% (24)
D
9% (3)

Explanation

Faster to access an index table.

Topics

#database index#query optimization#SQL#performance

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 98-361 Practice