98-361

98-361 practice questions, page 7 of 7, with answer review and explanations.

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?

  1. It reorders the records alphabetically.
  2. It speeds up query execution.
  3. It minimizes storage requirements.
  4. It reorders the records numerically.

Question 32

Which language was designed for the primary purpose of querying data, modifying data, and managing databases in a Relational Database Management System?

  1. Java
  2. SQL
  3. C++
  4. Visual Basic