Question: Suppose a PRODUCT table contains two attributes, PROD_CODE and VEND_ CODE. Those two attributes have values of ABC, 125, DEF, 124, GHI, 124, and JKL, 123, respectively. The VENDOR table contains a single attribute, VEND_CODE, with values 123, 124, 125, and 126, respectively. (The VEND_CODE attribute in the PRODUCT table is a foreign key to the VEND_CODE in the VENDOR table.) Given that information, what would be the query output for:
a. A UNION query based on the two tables?
b. A UNION ALL query based on the two tables?
c. An INTERSECT query based on the two tables?
d. An EXCEPT (MINUS) query based on the two tables?