What are the major differences between the UNION operation and the JOIN operation?

What is the major difference between the UNION and the UNION ALL?

What major set operator does SQL Server not have? How can these problems be resolved?

What does union compatibility mean?

What data types are union-compatible?

What is the maximum number of rows that can result from a UNION of two tablesone with 5 rows and the other with 6 rows?

What is the maximum number of rows that can result from a JOIN of two tablesone with 5 rows and the other with 6 rows?

How can a UNION be used to implement an outer join? Explain.

Does SQL Server support the MINUS operation? How can this be resolved? Give examples.

What is a full outer join? Does SQL Server directly support a full outer join?

Do you need the same number of columns to perform a union?

Do you need the same data types to perform a union?

Do you need the same number of columns to perform a join?

From the examples given in the chapter, what does the UNION JOIN appear to do?

If a VARCHAR column were unioned with a CHAR column, what would the resulting column be? (Hint: refer to the "Data Type Precedence" section in Chapter 6.)

What does set compatibility mean?

What is the maximum number of rows that can result from a INTERSECT of two tablesone with 5 rows and the other with 6 rows?

Do you need the same number of columns to perform an INTERSECT operation?

Do you need the same data types to perform an INTERSECT operation?