Write a query to perform the below Union Operation.Sample output:

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.

Write a query to perform the below Intersection Operation.

What does the UNION operation automatically eliminate in SQL?

Which of the following is the correct format to declare a union?Select one:a.union employee{ int age; long salary;};b.union Employee{ int age; long salary;} employee;c.union employee{ int age; long salary;} Employee;d.union Employee{ int age; long salary;};

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