Oracle Exam 1Z0-071 Topic 3 Question 83 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 83
Topic #: 3

[All 1Z0-071 Questions]

Examine these two queries and their output:

SELECT deptno, dname FROM dept;

SELECT ename, job, deptno FROM emp ORDER BY deptno;

Now examine this query:

SELECT ename, dname

FROM emp CROSS JOIN dept WHERE job = 'MANAGER'

AND dept.deptno IN (10, 20) ;

A64

D12

Show Suggested Answer

Suggested Answer: B

by Dulce at Dec 14, 2023, 09:23 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-071 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Renay

14 days ago

Hmm, the CROSS JOIN looks a bit suspicious to me. I wonder if there's a more efficient way to get the same result without generating a Cartesian product first. But I guess the answer is still D) 12.

upvoted 0 times

...

This seems straightforward. The CROSS JOIN will create a result set with all possible combinations of employees and departments, and the WHERE clause will restrict it to only managers in departments 10 and 20. The correct answer is D) 12.

upvoted 0 times

...

Luis

18 days ago

So the correct answer should be C) 3, as there are 3 managers in departments 10 and 20.

upvoted 0 times

...

29 days ago

I think the question is about joining tables based on certain conditions.

upvoted 0 times

...

Oracle Exam 1Z0-071 Topic 3 Question 83 Discussion

Contribute your Thoughts:

Renay

Yolande

Luis

Abel

Wilbert

Kimbery

Laila

Cassandra

Luis