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 is the first step toward implementing the physical database?
2. What factors should you take into consideration before creating a database?
3. What are the two steps that SQL Server uses when implementing a new database?
4. What methods can you use to create a SQL Server database object?
5. What is a data type?
6. What four attributes does a data type define for an object?
7. What are the nine categories of data types that SQL Server supports?
8. What are user-defined data types?
9. What type of information, at a minimum, should a table definition include?
10. What are you defining when you define column nullability in a table definition?
11. How do you define a default value for a column?
12. Which property can you use in the column definition of a CREATE TABLE statement in order to automatically generate an identity number for each new row added to a table?