Quick Check


1. 

Why is the width of rows important?

image from book

2. 

What does de-normalization imply?

de-normalization implies the storage of specific data redundantly.

3. 

Why should you avoid de-normalizing data that is frequently updated?

image from book

Answers

1. 

The width of rows is important because wide rows take up more space and can cause a waste of both memory and disk space.

2. 

De-normalization implies the storage of specific data redundantly.

3. 

You should avoid de-normalizing data that is frequently updated because of the cost of maintaining the redundant data.




MCITP Self-Paced Training Kit Exam 70-442  .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
ISBN: 073562383X
EAN: N/A
Year: 2007
Pages: 162

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net