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?

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

How the community answered

(59 responses)

A
12% (7)
B
80% (47)
C
2% (1)
D
7% (4)

Explanation

Faster to access an index table.

Topics

#database index#query performance#query optimization

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 98-361 Practice