PrepAway - Latest Free Exam Questions & Answers

Which statement will retrieve only the first name, last name, and telephone number for every student listed in

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?

PrepAway - Latest Free Exam Questions & Answers

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

7 Comments on “Which statement will retrieve only the first name, last name, and telephone number for every student listed in”

  1. Paul says:

    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?




    0



    0
  4. A Real Person says:

    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.




    0



    0

Leave a Reply