Examine the description of the EMPLOYEES table:
Which two queries will result in an error? (Choose two.)
A.
B.
C.
D.
E.
F.
1z0-071 Exam QuestionsBrowse all questions from this exam
1z0-071 Exam - Question 51
Show AnswerHide Answer
Correct Answer:
Discussion
10 commentswilliamsmith95
May 29, 2024Correct answer: C and E
Kashka
Sep 5, 2022Cannot use aliases in WHERE clause: ORA-00904: "ANNUAL_SALARY": invalid identifier
sqlwilly
Dec 12, 2022what about B. select first_name, last name from employees; - Will result in ORA-00904 invalid Identifier
J4vi
May 10, 2023BCE fail. Tested all.
zouve
Jul 5, 2023AB -> typos CE -> fails
alelejaja
May 29, 2024A could be using last_name as an alias too
NajiJabr
Jan 15, 2023A -- no comma separator between column names B- wrong column name last name it should be Last_Name
ninjax_m
Feb 6, 2023a,b,c,e will fail. Pick 2 :)
alelejaja
May 29, 2024A doesn't fail
shotcom
Apr 26, 2023a, b is typo error hence answer is CE because we cant use column aliase in the where clause Answer CE
alelejaja
May 29, 2024A could be using last_name as an alias of first_name
cadcadley
Jan 13, 2023CE is correct
TheOracleWasTaken
Aug 2, 2023C and E because of the alias used in the where clause