Oracle
1Z0-007 · Question #164
1Z0-007 Question #164: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-007 to reveal the answer and full explanation for question #164. The question stem and answer options stay visible for context.
Question
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?
Options
- ASELECT ename, salary*12 `Annual Salary'
- BSELECT ename, salary*12 "Annual Salary"
- CSELECT ename, salary*12 AS Annual Salary
- DSELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees
Unlock 1Z0-007 to see the answer
You've previewed enough free 1Z0-007 questions. Unlock 1Z0-007 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.