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
This is a tricky one, and it pays to slow down and read everything before answering.
I thought it’d be answer B, but upon closer inspection I saw that “telephoneNumber” is actually misspelled (telephoneNutnber)
However, won’t answer D (SELECT * FROM Students) also include the email address, which was specifically omitted in the question – therefore not be correct either?
I wouldn’t get too hung up on the misspelling. The person posting the question must have copied it wrong.
I agree with John, I already saw a lot of typos on this website, some of them are still the correct answer.
the correct is B for sure!
I did extensive research on this problem because it was bothering me too much. I found that the correct answer is neither D nor B, but it is the hidden answer, E. I mean, it’s the only one that makes sense.
E – SELECT All that stuff except for the email address, cha feel?
I just wanted to share this with you guys because this question is probably one of the more important ones on the test. I heard that if you don’t get this one right, you’ll fail the test for sure. So, although I won’t ask for a “Thank you”, you guys are welcome.
The syntax is wrong dude. It should be B. It just happened that the spelling was wrong but it was the nearest.
I believe the answer is B..
Since the question is quite specific, and the answer that make sense is only B..
I believe that was a Typo/Misspelling..
B is correct
Despite the typo in B, all other statements are improper syntax and will fail