Multiple choice technology databases

  1. With SQL, how do you select all the columns from a table named "Persons"?

  1. SELECT Persons

  2. SELECT *.Persons

  3. SELECT * FROM Persons

  4. SELECT [all] FROM Persons

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To select all columns from a table, you use SELECT * followed by FROM and the table name. The asterisk () is a wildcard that represents all columns in the table. Option A only selects the table name (not columns), B has incorrect syntax (.Persons), and D uses non-existent [all] syntax.

Keep practicing — related questions