Multiple choice technology databases

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

  1. SELECT Persons.FirstName ;

  2. EXTRACT FirstName FROM Persons ;

  3. SELECT FirstName FROM Persons;

  4. EXTRACT Persons.FirstName
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SELECT column FROM table is the correct syntax. EXTRACT is used for date/time parts, not general column selection.

Keep practicing — related questions