nerdexam
Microsoft

98-361 · Question #34

98-361 Question #34: Real Exam Question with Answer & Explanation

The correct answer is A. Option A. to sort use: ORDER BY LastName, FirstName

Question

In your student directory database, the Students table contains the following fields: - firstName - lastName - emailAddress - telephoneNumtoer You need to retrieve the data from the firstName, lastName, and emailAddress fields for all students listed in the directory. The results must be in alphabetical order according to lastName and then firstName. Which statement should you use?

Exhibit

98-361 question #34 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

Explanation

to sort use: ORDER BY LastName, FirstName

Community Discussion

No community discussion yet for this question.

Full 98-361 Practice