Multiple choice technology databases

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

  1. SELECT ename, salary*12 'Annual Salary' FROM employees;

  2. SELECT ename, salary*12 "Annual Salary" FROM employees;

  3. SELECT ename, salary*12 AS Annual Salary FROM employees;

  4. SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL, column aliases containing spaces must be enclosed in double quotes. Option B correctly uses "Annual Salary" with double quotes. Option A uses single quotes (string literal syntax, not alias syntax). Option C's AS clause without quotes would fail due to the space. Option D unnecessarily uses INITCAP function and incorrect alias syntax.

Keep practicing — related questions