Chapter 10 Review: A Practical Guide to Red Hat Linux by Mark G. Sobell

Assignment: Chapter 10 Review Exercise 1-10

1. What is the Enterprise Manager in SQL Server? It is used to carry out the most common administrative tasks, including creating databases, indexes, and other database objects. P301

2. What is the Tree pane used for? Shows the structure of your SQL Server enviorment.

3. What are the data types available in SQL Server? Text, varchar, char, ntext, nvarchar, nchar, bigint, int, smallint, tinyint, bit, numeric, decimal, float, real, datetime, smalldatetime, timestamp, money, smallmoney, varbinary, binary, image, there are also less commonly used datatypes.

4. What is a reserved word? A word that has special meaning in SQL cannot be used to name objects. P305

5. What is the purpose for a check constraint for a column? A setting for a column where you can specify a condition that data values must conform to when being inserted into the column. P306

6. How is primary key specified? First, create a database diagram go to table view then right click the field and chose ‘Set Primary Key’. P306-309

7. What is the datasheet view used for? It is used to enter data into the database. P310

8. How is a relationship created in SQL Server? First, the FK and PK must have the same column widths and data types.