Answer each of the following questions labeling your answers clearly. Save your work in the Desire 2 Learn Dropbox for Week 06 - Review Questions.
1. What type of integrity is enforced when a primary key is declared?
2. 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.
3. Explain two major components of SQL.
4. What is the difference between a column constraint and a table constraint?
5. Write the SQL command that will create a user-defined data type called KEY_CODE for all the primary keys containing character values with a length of 7.
6. Within the context of a database, explain authentication.
7. What is the objective of SQL?
8. Describe the two types of tables that exist in a database.
9. What are "referential constraint actions"?
10. Write the SQL command that will delete the EMPLOYEE table from the database.
11. Explain why it would be preferable to use a DATE data type to store date data instead of a character data type.
12. What is a database?
13. What is a user-defined data type?Why is it used?
14. Describe the purpose of the IDENTITY property.
15. Within the context of a database, what are constraints?
16. If you create a database called inventory, what two files are created?
17. Within the context of a database, what is a table?
18. What special meaning does using the @, @@, # and ## symbols have at the beginning of an identifier?
19. List and explain three constraints.
20. Write the SQL code command that will drop the PAYROLL database.