Chapter 10 Review: A Practical Guide to Red Hat Linux by Mark G. Sobell
Essay title: Chapter 10 Review: A Practical Guide to Red Hat Linux by Mark G. Sobell
Assignment: Chapter 10 Review Exercise 1-10
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
What is the Tree pane used for? Shows the structure of your SQL Server enviorment.
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.
What is a reserved word? A word that has special meaning in SQL cannot be used to name objects. P305
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
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
What is the datasheet view used for? It is used to enter data into the database. P310
How is a relationship created in SQL Server? First, the FK and PK must have the same column widths and data types.