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?
A.
WHERE Students SELECT *
B.
SELECT firstName, lastName, telephoneNutnber FROM Students
C.
SELECT firstName, lastName, telephoneNumber IN Students
D.
SELECT * FROM Students
E.
WHERE Students SELECT firstName, lastName, telephoneNumber
The correct answer is B
Yes, the correct answer is B! Because * will choose all the information from this table