PrepAway - Latest Free Exam Questions & Answers

Which of the following SQL statements will select the fields name and address from the contacts table?

Which of the following SQL statements will select the fields name and address from the contacts table?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT (name, address) FROM contacts;

B.
SELECT (name address) FROM contacts;

C.
SELECT name, address FROM contacts;

D.
SELECT name address FROM contacts;

Explanation:
see http://www.sqlite.org/syntaxdiagrams.html#select-stmt for a detailed description of the SQL select syntax.


Leave a Reply