1Z0-071 practice - PrepKeys

Q2 Single choice

Examine this query Which executes successfully:

SELECT job, deptno FROM emp

UNION ALL

SELECT job, deptno FROM jobs_ history;

What will be the result?

A
It will return rows common to both SELECT statements.
B
It will return rows from both SELECT statements after eliminating duplicate rows.
C
It will return rows that are not common to both SELECT statements.
D
It will return rows from both SELECT statements including duplicate rows.