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

In SQL, the asterisk (*) wildcard character is used in the SELECT clause to specify that all columns from the target table should be returned. Options using "all columns" or "distinct columns" are syntactically invalid in standard SQL.

Keep practicing — related questions