Review

3 4

The following questions are intended to reinforce key information presented in this chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. You can find answers to the questions in Appendix A, "Questions and Answers."

1. What properties within a SQL Server database are used to enforce data integrity?
2. What is the difference between a DEFAULT definition and a NOT NULL definition?
3. What are the advantages of using CHECK constraints rather than rules?
4. What four types of data integrity does SQL Server support?
5. What are the differences between entity integrity and domain integrity?
6. Which type of integrity preserves the defined relationships between tables when records are entered or deleted?
7. What types of constraints does SQL Server support?
8. How many PRIMARY KEY constraints can be included in a table definition?
9. When should you use a UNIQUE constraint rather than a PRIMARY KEY constraint?
10. What does SQL Server check for in the existing data when a PRIMARY KEY constraint is added to an existing column (or columns)?
11. What is a FOREIGN KEY constraint, and how is it created?
12. How does a CHECK constraint determine what values are valid?