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 166 discussion

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

You must find the number of employees whose salary is lower than employee 110.

Which statement fails to do this?

  • A.
  • B.
  • C.
  • D.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by jfc1 at March 3, 2023, 1:42 p.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
alic_alex
Highly Voted 2 years, 3 months ago
fail A - because in the subquery exist condition referenced to main table but not subquery table. By other words, in the subquery not exist limitation for fetching rows and subquery return more than one row
upvoted 7 times
...
salander71
Most Recent 8 months, 3 weeks ago
A is not correct, failed with "ORA-01427: single-row subquery returns more than one row"
upvoted 1 times
...
TomZh
1 year ago
Selected Answer: A
A -failed with "ORA-01427: single-row subquery returns more than one row"
upvoted 1 times
...
7dc4ae8
1 year ago
A fails
upvoted 2 times
...
ArslanAltaf
1 year, 1 month ago
AD Both similar results. A should be preferred
upvoted 1 times
...
[Removed]
1 year, 3 months ago
Selected Answer: A
Because it is incorret
upvoted 1 times
...
deepzsiva
1 year, 5 months ago
Correct Answer is A. Tested.
upvoted 1 times
...
Arth1989
1 year, 5 months ago
alic_alex, I am sorry but where did you see the EXIST condition in A?
upvoted 2 times
...
lucemqy
1 year, 7 months ago
Selected Answer: A
A is correct
upvoted 1 times
...
zouve
2 years ago
Selected Answer: A
is the A the correct A is select count(*) from hr.employees e where e.salary < (select a.salary from hr. employees a where a.employee_id=110);
upvoted 2 times
...
Rik92
2 years, 2 months ago
Selected Answer: A
Answer by alic_alex explains it well.
upvoted 1 times
...
Darnun
2 years, 3 months ago
Selected Answer: A
A fails due to the wrong condition in subquery
upvoted 1 times
...
Beesho
2 years, 3 months ago
i would say A
upvoted 1 times
...
jfc1
2 years, 3 months ago
Selected Answer: C
A,B,D give the same result. But C is different I suggest C
upvoted 1 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