EssaysForStudent.com - Free Essays, Term Papers & Book Notes
Search

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

By:   •  Essay  •  357 Words  •  November 8, 2009  •  935 Views

Page 1 of 2

Essay title: 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.

Continue for 1 more page »  •  Join now to read essay Chapter 10 Review: A Practical Guide to Red Hat Linux by Mark G. Sobell and other term papers or research documents
Download as (for upgraded members)
txt
pdf
Citation Generator

(2009, 11). Chapter 10 Review: A Practical Guide to Red Hat Linux by Mark G. Sobell. EssaysForStudent.com. Retrieved 11, 2009, from https://www.essaysforstudent.com/essays/Chapter-10-Review-A-Practical-Guide-to-Red/2081.html

"Chapter 10 Review: A Practical Guide to Red Hat Linux by Mark G. Sobell" EssaysForStudent.com. 11 2009. 2009. 11 2009 <https://www.essaysforstudent.com/essays/Chapter-10-Review-A-Practical-Guide-to-Red/2081.html>.

"Chapter 10 Review: A Practical Guide to Red Hat Linux by Mark G. Sobell." EssaysForStudent.com. EssaysForStudent.com, 11 2009. Web. 11 2009. <https://www.essaysforstudent.com/essays/Chapter-10-Review-A-Practical-Guide-to-Red/2081.html>.

"Chapter 10 Review: A Practical Guide to Red Hat Linux by Mark G. Sobell." EssaysForStudent.com. 11, 2009. Accessed 11, 2009. https://www.essaysforstudent.com/essays/Chapter-10-Review-A-Practical-Guide-to-Red/2081.html.