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."
- What is the first step toward implementing the physical database?
- What factors should you take into consideration before creating a database?
- What are the two steps that SQL Server uses when implementing a new database?
- What methods can you use to create a SQL Server database object?
- What is a data type?
- What four attributes does a data type define for an object?
- What are the nine categories of data types that SQL Server supports?
- What are user-defined data types?
- What type of information, at a minimum, should a table definition include?
- What are you defining when you define column nullability in a table definition?
- How do you define a default value for a column?
- 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?