Multiple choice technology databases

To select all the columns from a table EMP, which one of the following is TRUE?

  1. Select all columns from EMP;

  2. Select distinct columns from EMP;

  3. Select * from EMP;

  4. All of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The asterisk (*) wildcard in SQL selects all columns from a table. 'SELECT * FROM EMP' is the correct syntax. Options A and B are not valid SQL syntax - 'Select all columns' is not valid SQL, and 'distinct columns' is incorrect syntax.

Keep practicing — related questions