-
SELECT on a MERGE table is like _____________.
-
- UNION
- JOIN
- UNION ALL
- UNION DISTINCT
- None of these
Correct Option: C
Performing a ‘SELECT’ operation on a ‘MERGE’ table is like performing ‘UNION ALL’. This means that duplicate row results are not removed. ‘SELECT DISTINCT’ is like ‘UNION’ or ‘UNION DISTINCT’.