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.

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.

Write a query to perform the below Union Operation.

What does the UNION operation automatically eliminate in SQL?

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

What is the purpose of the SQL UNION operator?