Exam 1z0-071 All QuestionsBrowse all questions from this exam
Go to Exam
Question 51

Examine the description of the EMPLOYEES table:

Which two queries will result in an error? (Choose two.)

A.

B.

C.

D.

E.

F.

    Correct Answer:

Discussion
williamsmith95

Correct answer: C and E

sqlwilly

what about B. select first_name, last name from employees; - Will result in ORA-00904 invalid Identifier

Kashka

Cannot use aliases in WHERE clause: ORA-00904: "ANNUAL_SALARY": invalid identifier

zouve

AB -> typos CE -> fails

alelejaja

A could be using last_name as an alias too

J4vi

BCE fail. Tested all.

shotcom

a, b is typo error hence answer is CE because we cant use column aliase in the where clause Answer CE

alelejaja

A could be using last_name as an alias of first_name

ninjax_m

a,b,c,e will fail. Pick 2 :)

alelejaja

A doesn't fail

NajiJabr

A -- no comma separator between column names B- wrong column name last name it should be Last_Name

TheOracleWasTaken

C and E because of the alias used in the where clause

cadcadley

CE is correct