Microsoft
98-361 · Question #34
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…
Sign in or unlock 98-361 to reveal the answer and full explanation for question #34. The question stem and answer options stay visible for context.
Understanding Databases
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
Options
- AOption A
- BOption B
- COption C
- DOption D
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
#SELECT statement#ORDER BY#SQL query#data retrieval