MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 - Database Development comments and corrections

Article translations Article translations
Article ID: 973440
Expand all | Collapse all

On This Page

Summary

This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCTS Self-Paced Training Kit (Exam 70-433): Microsoft SQL Server 2008 - Database Development, 978-0-7356-2639-3.

The following topics are covered:

  • CD-ROM: Answer options missing from practice test question
  • CD-ROM: Answer option incorrect in practice test question
  • Page xx: Digital Content link incorrect
  • Page 20: "across all subcategories" should be "without a ProductSubcategoryID"
  • Page 202: cheaper should be more expensive
  • Page 330: Code sample is missing
  • Page 331: Sample file is missing
  • Page 424: "sp_send_db mail" should be "sp_send_dbmail"

More information

CD-ROM: Answer options missing from practice test question

In the practice test included on the Companion CD, question 433P_2.3_03 is missing two portions of the correct answer.

The question reads:
"Your company uses two tables to track current and past employees, named Employees and FormerEmployees. Both tables use the same columns: employeeID, name, department, and homePhone. You must create a Data Manipulation Language (DML) trigger to transfer any employees deleted from the Employees table into the FormerEmployees table."

One answer possibility is missing:
"(employeeID, name, department, homePhone)"

One answer possibility is incorrect. Change:
"SELECT" To: "SELECT (employeeID, name, department, homePhone)"

The correct order of answers is:
"CREATE TRIGGER TR_moveEmployee ON
Employees
AFTER
DELETE
AS
INSERT
INTO
FormerEmployees
(employeeID, name, department, homePhone)
SELECT (employeeID, name, department, homePhone)
FROM
deleted "

CD-ROM: Answer option incorrect in practice test question

In the practice test included on the Companion CD, question 433P_4.1_04 has an incorrect answer option.

The question reads:
"You have a table named Pets, which contains the following columns:

petName, which stores the name of the pet
ownerName, which stores the name of the pet's owner

You also have a table named Owners, which contains the following columns:
ownerName, which stores the name of the owner of one or more pets
age, which stores the age of the owner
location, which stores the name of the city in which the owner lives

You must retrieve the pet's name, owner's name, and pet’s age for all pet owners over the age of 50 who live in Seattle.

From the list on the right, select the portion of the statement you should use. Place your selections in the list on the left in the order in which they appear in the statement. Place your selections in the list on the left by clicking the items in the list on the right and clicking the arrow button. You can also use the up and down buttons to rearrange items in the list on the left. You may not need to use all the items from the list on the right."

The answer option:
"(SELECT age FROM Owners WHERE location = 'Seattle') AS own"

Should read:
"(SELECT ownerName, age FROM Owners WHERE location = 'Seattle') AS own"

Page xx: Digital Content link incorrect

On page xx, in the Digital Content for Digital Book Readers box near the top of the page, the link is incorrect.

Change:
http://go.microsoft.com/fwlink/?LinkId=139187

To:
http://go.microsoft.com/fwlink/?LinkID=146933

Page 20: "across all subcategories" should be "without a ProductSubcategoryID"

On page 20, the last sentence of the "Using the GROUP BY Clause" section is incorrect.

Change:
"The top row, where the ProductSubcategoryID is listed as NULL, is the summary row that provides the average, minimum, and maximum list prices of products across all subcategories."

To:
"The top row, where the ProductSubcategoryID is listed as NULL, is the summary row that provides the average, minimum, and maximum list prices of products without a ProductSubcategoryID."

Page 202: cheaper should be more expensive

On page 202, the third sentence of the “Subqueries Without Correlation to the Outer Query” section is incorrect.

Change:
“The following example uses a subquery to return all products that are cheaper than the average product price.”

To:
“The following example uses a subquery to return all products that are more expensive than the average product price.”

Page 330: Code sample is missing

On page 330, the second sentence of the first paragraph refers to code that is not printed in the book.

Change:
"The following code defines a geography type variable and sets the variable to a line between two points."

To:
"You can define a geography type variable and set the variable to a line between two points."

Page 331: Sample file is missing

On page 331, step 5 refers to a sample file named Airport.xls, which is not available. This section of the practice should be disregarded.

Page 424: "sp_send_db mail" should be "sp_send_dbmail"

On page 424, the first bullet under "Chapter Summary" contains an incorrect command.

Change:
"You can use the sp_send_db mail to integrate e-mail messages into your database applications."

To:
"You can use the sp_send_dbmail to integrate e-mail messages into your database applications."

Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.

Properties

Article ID: 973440 - Last Review: June 21, 2014 - Revision: 2.0
Keywords: 
KB973440

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com