1. 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 specific examples (3) that are not in the book and explain why for each.
2. What is the difference between a column constraint and a table constraint?  Provide a complete SQL Oracle example of each in a table that is different from what is in the book. 
3. What is the purpose of a CHECK constraint? Give an example different from the book. Use complete SQL Oracle code in example.
4. What is a trigger, and what is its purpose? Give a complete trigger example in SQL Oracle code that is different from the book and explain what it is doing. Do NOT just show the syntax of a trigger.  
5. 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. Do NOT just show the syntax of a stored procedure.

Answer rating: 100% (QA)

1 Declaring an attribute that contains only digits as a character data type Example 1 A column storing a postal code eg 98121 may be better as a chara... View the full answer