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…
The correct answer is B. SELECT firstName, lastName, telephoneNutnber FROM Students. Use SELECT...FROM and list the fields you want to retrieve.
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
How the community answered
(27 responses)- A11% (3)
- B78% (21)
- C7% (2)
- E4% (1)
Explanation
Use SELECT...FROM and list the fields you want to retrieve.
Topics
#SQL SELECT#column selection#FROM clause#query syntax
Community Discussion
No community discussion yet for this question.