Which statement is true about the INTERSECT operator used in compound queries?
A. INTERSECT is of lower precedence than UNION or UNION ALL.
B. Multiple INTERSECT operators are not possible in the same SQL statement.
C. It ignores NULLs.
D. It processes NULLs in the selected columns.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
CORRECT ANSWER: D
A) All the SET operators share the same degree of precedence among them
B) Multiple INTERSECT operators in the same SELECT statement are evaluated left to right, unless parentheses dictate otherwise.
C)Intersect does not ignore null values