Q26 Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
- (A). Duplicates are eliminated automatically by the UNION ALL operator
- (B). The number of columns selected in each SELECT statement must be identical
- (C). The names of columns selected in each SELECT statement must be identical
- (D). The output is sorted by the UNION ALL operator
- (E). NULLS are not ignored during duplicate checking
Answer: B,E