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?
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.
This section is not available anymore. Please use the main Exam Page.1z0-071 Exam Questions
Log in to ExamTopics
Sign in:
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.
Artur1991
Highly Voted 2 years, 10 months agoWadyba
11 months agopukovnik
10 months, 2 weeks agobca123
Most Recent 6 months, 2 weeks agoMassy
3 weeks, 2 days agoNelita
2 years, 1 month agocadcadley
2 years, 5 months agodexdinh91
2 years, 5 months ago