DB Questions ***FOR AROKA ONLY***

About 90 - 100 words or more per question.

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.