Microsoft
98-361 · Question #88
You are creating a database for a student directory. The Students table contains the following fields: Which statement will retrieve only the first name, last name, and telephone number for every…
Sign in or unlock 98-361 to reveal the answer and full explanation for question #88. The question stem and answer options stay visible for context.
Understanding Databases
Question
You are creating a database for a student directory. The Students table contains the following fields:
Which statement will retrieve only the first name, last name, and telephone number for every student listed in the directory?
Options
- AWHERE Students SELECT *
- BSELECT firstName, lastName, telephoneNutnber FROM Students
- CSELECT firstName, lastName, telephoneNumber IN Students
- DSELECT * FROM Students
- EWHERE Students SELECT firstName, lastName, telephoneNumber
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
#SQL SELECT#column selection#FROM clause#query syntax