Multiple choice technology databases

Select the incorrect Oracle Select Statement

  1. select distinct * from T1

  2. select C1 from T1 order by C2

  3. select distinct C1 from T1

  4. select 12*14 from T1

  5. select C1 AS 'column1",C1 AS 'column2',C2 AS 'column1' from T1.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Option B is incorrect because it uses ORDER BY C2 without C2 being in the SELECT list, which is invalid Oracle SQL. The other options are valid: DISTINCT can be used with * or specific columns, arithmetic expressions in SELECT are allowed, and column aliases can be repeated though it's poor practice.

Keep practicing — related questions