Multiple choice technology databases

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

  1. SELECT * FROM Persons

  2. SELECT [all] FROM Persons

  3. SELECT Persons

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

In SQL, the asterisk (*) wildcard character is used to select all columns from a table. The correct syntax is 'SELECT * FROM table_name' as shown in option A. Options B, C, and D use incorrect syntax - SQL doesn't use [all] keyword this way, requires a column list or *, and cannot have empty SELECT clause.

Keep practicing — related questions