Oracle Database 12c SQL 1z0-071 Question # 90 Topic 10 Discussion

Oracle Database 12c SQL 1z0-071 Question # 90 Topic 10 Discussion

1z0-071 Exam Topic 10 Question 90 Discussion:
Question #: 90
Topic #: 10

1z0-071 Question 90

Which two queries will result in an error?


A.

SELECT FIRST_NAME LAST_NAME FROM EMPLOYEES;


B.

SELECT FIRST_NAME,LAST_NAME FROM EMPLOYEES;


C.

SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY

FROM EMPLOYEES

WHERE ANNUAL_SALARY > 100000

ORDER BY 12 * SALARY ;


D.

SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY

FROM EMPLOYEES

WHERE 12 * SALARY > 100000

ORDER BY ANNUAL_SALARY;


E.

SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY

FROM EMPLOYEES

WHERE 12 * SALARY > 100000

ORDER BY 12 * SALARY;


F.

SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY

FROM EMPLOYEES

WHERE ANNUAL_SALARY > 100000

ORDER BY ANNUAL_SALARY;


Get Premium 1z0-071 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.