1. What is the difference between a column constraint and a table constraint?
2. What is a recursive join?
3. Explain the difference between an ORDER BY clause and a GROUP BY clause.
4. What is a CROSS JOIN? Give an example of its syntax.
5. What three join types are included in the OUTER JOIN classification?
6. What is a correlated subquery? Give an example.
7. What is a subquery, and what are its basic characteristics?
8. What is a trigger, and what is its purpose? Give an example.
9. What is a stored procedure, and why is it particularly useful? Give an example.