Multiple choice technology databases

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

  1. SELECT Persons.FirstName

  2. SELECT FirstName FROM Persons

  3. EXTRACT FirstName FROM Persons

  4. None
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To select a specific column from a table, use SELECT column_name FROM table_name. This retrieves only the specified column for all rows. Option A uses incorrect dot notation (Persons.FirstName), C uses non-existent EXTRACT keyword, and the syntax for column selection is simply SELECT followed by the column name.

Keep practicing — related questions