The UNION of two tablesa.is a table containing all rows that are in the first table but not in the second table.b.is a table containing all rows that are in the second table but not in the first table.c.is a table containing all rows that are in either table or both.d.is a table containing all rows that are common to both tables.

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.

Which of the following is a UNION query?Question 3Select one:a.Combines the output from no more than two queries and must include the same number of columns.b.Combines the output from no more than two queries and does not include the same number of columns.c.Combines the output from multiple queries and must include the same number of columns.d.Combines the output from multiple queries and does not include the same number of columns.

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

What is the key difference between a structure and a union in C?*1 pointA structure can store multiple data types, a union cannotA union can store multiple data types, a structure cannotIn a structure, only one member can be accessed at a timeIn a union, only one member can be accessed at a time

Table A and Table B are to be joined in a query.Which type of join will include all rows from tables A and B in the result?