In which scenario would using UNION ALL be preferable over UNION in SQL?Question 16Answera.When you want to filter out NULL values from the result setb.When you want to sort the combined result set based on a specific columnc.When you want to eliminate duplicate rows from the combined result setd.When you want to merge result sets while preserving duplicate rows

6.  What’s the difference between UNION and JOIN?   A. UNION combines rows from two tables into a single result set, keeping all duplicates; JOIN combines the results of two queries based on a related column.B. UNION can only be used with SELECT statements; JOIN can be used with any SQL statementC. UNION is used to combine columns from two tables; JOIN is used to combine rows from two tablesD. UNION combines the results of two queries into a single result set, removing duplicates; JOIN combines columns from two or more tables based on a related column.

A UNION query is which of the following?Combines the output from multiple queries and must include the same number of columns.Combines the output from no more than two queries and must include the same number of columns.Combines the output from multiple queries and does not include the same number of columns.Combines the output from no more than two queries and does not include the same number of columns.

What does the UNION operation automatically eliminate in SQL?

What does the UNION operation automatically eliminate in SQL?Null values.Duplicate tuples.Relations with different schemas.Operations on virtual relations.

Select the correct answerWhat is the purpose of the SQL UNION operator?OptionsCombines rows from two or more tables, removing duplicatesCombines rows from two or more tables, including duplicatesSorts rows in a tableDeletes rows from a table