ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-071 All Questions

View all questions & answers for the 1z0-071 exam
Go to Exam

Exam 1z0-071 topic 1 question 51 discussion

Actual exam question from Oracle's 1z0-071
Question #: 51
Topic #: 1
[All 1z0-071 Questions]

Examine the description of the EMPLOYEES table:

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

B.

C.

D.

E.

F.

Show Suggested Answer Hide Answer
Suggested Answer: CE
by Kashka at Sept. 5, 2022, 5:01 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
williamsmith95
Highly Voted 5 months ago
Correct answer: C and E
upvoted 13 times
...
Kashka
Highly Voted 2 years, 1 month ago
Cannot use aliases in WHERE clause: ORA-00904: "ANNUAL_SALARY": invalid identifier
upvoted 5 times
...
wojtekb
Most Recent 1 month ago
A - logical typo but still will work B - Won't work because if _ is missing oracle does not recognize column (invalid identifier) C - Won't work because you can't use aliases in where clause D - Works E - The same as C F - Works Answers : A, C, E Tested on Oracle live
upvoted 1 times
wojtekb
1 month ago
*Meant ofc BCE
upvoted 1 times
...
...
TheOracleWasTaken
1 year, 3 months ago
C and E because of the alias used in the where clause
upvoted 4 times
...
zouve
1 year, 3 months ago
AB -> typos CE -> fails
upvoted 5 times
alelejaja
5 months ago
A could be using last_name as an alias too
upvoted 2 times
...
...
J4vi
1 year, 5 months ago
BCE fail. Tested all.
upvoted 3 times
...
shotcom
1 year, 6 months ago
a, b is typo error hence answer is CE because we cant use column aliase in the where clause Answer CE
upvoted 2 times
alelejaja
5 months ago
A could be using last_name as an alias of first_name
upvoted 2 times
...
...
ninjax_m
1 year, 9 months ago
a,b,c,e will fail. Pick 2 :)
upvoted 2 times
alelejaja
5 months ago
A doesn't fail
upvoted 2 times
...
...
NajiJabr
1 year, 9 months ago
A -- no comma separator between column names B- wrong column name last name it should be Last_Name
upvoted 2 times
...
cadcadley
1 year, 9 months ago
CE is correct
upvoted 1 times
...
sqlwilly
1 year, 10 months ago
what about B. select first_name, last name from employees; - Will result in ORA-00904 invalid Identifier
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago