Question 2:
Which statement is true about the INTERSECT operator used in compound queries?
Answer options:
A. Multiple INTERSECT operators are not possible in the same SQL statement B. It processes NULLs in the selected columns C. INTERSECT is of lower precedence than UNION or UNION ALL D. It ignores NULLs