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

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

Examine these two queries and their output:
SELECT deptno, dname FROM dept;

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

Now examine this query:

How many rows will be displayed?

  • A. 64
  • B. 6
  • C. 3
  • D. 12
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Artur1991 at Sept. 4, 2022, 2:11 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
Artur1991
Highly Voted 2 years, 10 months ago
B is correct answer From first table it will take 2 records, from second table it will take 3 records. After cross join we will have 6 records (2x3).
upvoted 6 times
Wadyba
11 months, 2 weeks ago
but the 3rd manager has a deptno = 30, so I think it should be dropped.
upvoted 1 times
pukovnik
11 months ago
deptno in where clause does not relate to deptno column i emp table but dept table. So basically it's taking all managers from emp table(three of them), departments 10 and 20 from dept table and making cartesian product out of those.
upvoted 1 times
...
...
...
bca123
Most Recent 6 months, 4 weeks ago
Selected Answer: A
Ans is 4 cause each manager from from emp table (clark and jones) is matched with both dept table (10,20)---2*2=4
upvoted 1 times
Massy
1 month ago
what about blake?
upvoted 1 times
...
...
Nelita
2 years, 1 month ago
Selected Answer: B
B IS CORRECT.
upvoted 3 times
...
cadcadley
2 years, 6 months ago
B is correct because in emp table he take all manager rows then in dept he take 10 and 20 will be 3*2=6
upvoted 2 times
...
dexdinh91
2 years, 6 months ago
Selected Answer: B
3 x 2 = 6 so B
upvoted 2 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