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. SELECT FROM FirstName IN Persons
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Selecting a column requires the SELECT columnName FROM tableName syntax. Therefore, SELECT FirstName FROM Persons is correct. SELECT Persons.FirstName lacks the mandatory FROM clause, EXTRACT is not the correct command, and the IN syntax is invalid for basic column retrieval.

Keep practicing — related questions