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

Previous Question
Next Question

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

A.
SELECT ename, salary*12 ‘Annual Salary’
FROM employees;

B.
SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”)
FROM employees

C.
SELECT ename, salary*12 “Annual Salary”
FROM employees;

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

Explanation:

This SQL statement provides correct syntax to generate the alias Annual Salary for the calculated
column SALARY*12.

Previous Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *