Questions 1 to 10

Review Questions 1. How do you join tables in SQL? 2. When must you qualify names in SQL commands? How do you qualify a column name? 3. List two operators that you can use with subqueries as an alternate way of performing joins. 4. What is a nested subquery? In which order does SQL evaluate nested subqueries? 5. What is an alias? How do you specify an alias in SQL? How do you use an alias? 6. How do you join a table to itself in SQL? 7. How do you take the union of two tables in SQL? How do you take the intersection of two tables in SQL? How do you take the difference of two tables in SQL? Are there any restrictions on the tables when performing any of these operations? 8. What does it mean for two tables to be union compatible? 9. How do you use the ALL operator with a subquery? 10. How do you use the ANY operator with a subquery? 11. Which rows are included in an inner join? What clause can you use to perform an inner join n SQL? 12. Which rows are included in a left outer join? What clause can you use to perform a left outer join in SQL? 13. Which rows are included in a right outer join? What clause can you use to perform a right outer join in SQL? 14. What is the formal name for the product of two tables? How do you form a product in SQL? 15. Use the Internet to find definitions for the terms equi-join, natural join, and cross join. e Write a short report that identifies how these terms relate to the terms join, inner join, and NG Cartesian product. Be sure to reference your online sources properly