Multiple choice technology databases

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

  1. EXTRACT FirstName FROM Persons

  2. SELECT FirstName FROM Persons

  3. SELECT Persons.FirstName

  4. SELECT * FROM Persons
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The correct SQL syntax for selecting a specific column is 'SELECT column_name FROM table_name' as shown in option B. Option A uses EXTRACT which is for date/time parts, option C uses table.column format without proper context, and option D uses the wildcard to select all columns instead of just FirstName.

Keep practicing — related questions