LPI Exam Questions

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

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

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.