|
|
This page is dedicated to identifying and sharing errors identified in the MCITP
SQL Server Database Developer
All-In-One book.
The following errors have been identified in the MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) (All-in-One)
book.
|
Page |
Correction |
|
82 |
The last sentence in fifth bullet under Self Study Exercises should read as "Modify
the WinLossRecord data type to accommodate data beyond 8K." There is no track
data type |
|
89 |
Answer 3. The answer should be A, C and D. The explanation should read as "Indexes
cannot be created on computed columns that are nondeterministic such as GetDate()
but can be created on computed columns that are deterministic such as Month()." |
|
89 |
Answer 5. The answers given are correct but the first sentence in the explanation
should read "The primary restriction on creating indexes on computed columns is
that the computed column must be deterministic and precise." |
|
155 |
Step 8 in exercise 4.4 on page 155
The following script returns all the rows instead of filtering them.
SELECT Name, ProductNumber, StandardCost, ListPrice
FROM Production.Product
WHERE EXISTS
(SELECT * FROM Production.Product WHERE ProductNumber LIKE '[A-C]%');
Since the subquery evaluates as true, it selects all 504 rows of the Product table
without filtering for the ProductNumber beginning with letters A through C.
Thanks to Mark Sykes who provided this alternative:
SELECT Name, p1.ProductNumber, StandardCost, ListPrice
FROM Production.Product p1
WHERE EXISTS
(SELECT 1 FROM Production.Product p2 WHERE p2.ProductNumber LIKE '[A-C]%'
AND p1.ProductNumber = p2.ProductNumber);
It returns the expected 121 rows with the ProductNumber properly filtered.
|
If you know of errors in this book, please
let me know.
|
|