Given the following two tables:
TAB1
R1
—
ABCDE
TAB2
R2
—
ABCD
Which of the following queries returns the following result set?
RETVAL
——
E
A.
SELECT r1 ASretval FROM tab1
INTERSECT
SELECT r2 AS retval FROM tab2
B.
SELECT r1 ASretval FROM tab1
EXCEPT
SELECT r2 AS retval FROM tab2
C.
SELECT DISTINCT r1 ASretval
FROM tab1, tab2
WHERE r1 <> r2
D.
SELECT r1 ASretval FROM tab1
UNION
SELECT r2 AS retval FROM tab2