All questions below pertain to material learned from the textbook (Chapter 8) and lectures.Please put all answers to the questions below in this document for grading. Please do NOT submit answers without the questions. Please note that most questions require unique examples that are not taken directly from the book. The reason for this is to provide you the opportunity to do some critical thinking with the material learned.

1. (3 points) Explain why it might be more appropriate to declare an attribute that contains only digits as a character data type instead of a numeric data type. Give a specific example that is not in the book. Explain why.
2. (3 points) What is the difference between a column constraint and a table constraint? Provide a specific SQL Oracle example of each that is different from what is in the book. Use Oracle code in examples.
3. (3 points) What is the purpose of a CHECK constraint?Give an example different from the book.Use SQL Oracle code in example.
4. (3 points) What is a trigger, and what is its purpose? Give a complete example in SQL Oracle code that is different from the book and explain what it is doing.
5. (3 points) What is a stored procedure, and why is it particularly useful?Give a specific and complete SQL example in Oracle code that is different from the book and explain what it is doing.