Microsoft KB Archive/271783

= Readiness Review 70-029: Designing and Implementing Databases with SQL Server 7 Comments and Corrections =

Article ID: 271783

Article Last Modified on 3/1/2007

-

APPLIES TO


 * MSPRESS MCSE Readiness Review Exam 70-029 Designing and Implementing Databases with Microsoft SQL Server 7.0 ISBN 0-7356-0673-0

-



This article was previously published under Q271783



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCSE Readiness Review: Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7, ISBN 0-7356-0673-0.

The following topics are covered:


 * Pages 117 And 118: Missing Space In The Transact-SQL Batch
 * Page 175: Change &quot;ORDER BY line_item_id&quot; To &quot;ORDER BY product_id&quot;
 * Pages 181-186: &quot;Inventory&quot; Should Be &quot;Product&quot;
 * Page 228: Error In Answer D



Pages 117 And 118: Missing Space In The Transact-SQL Batch
On pages 117 and 118, in question 70-029.03.01.005, the listed Transact-SQL batch contains an error. There should be a space before the SELECT command in order for the batch to run correctly.

Change:

&quot;N'SELECT&quot;

To:

&quot;N' SELECT&quot;

Page 175: Change &quot;ORDER BY line_item_id&quot; To &quot;ORDER BY product_id&quot;
On page 175, in question 70-029.03.05.006, change:

&quot;ORDER BY line_item_id&quot;

To:

&quot;ORDER BY product_id&quot;

Pages 181-186: &quot;Inventory&quot; Should Be &quot;Product&quot;
Pages 181-186 contain three questions with the same error. In questions 70-029.03.06.001, 70-029.03.06.002 and 70-029.03.06.003, the last sentence should be changed from:

&quot;Each manufacturer_id column in the inventory table is a foreign key set to...&quot;

To:

&quot;Each manufacturer_id column in the product table is a foreign key set to...&quot;

Page 228: Error In Answer D
On page 228 in answer D, change:

&quot;The SELECT clause identifies the first_name and last_name columns. These are the values that will be returned in the result set.&quot;

To:

&quot;The SELECT clause identifies the salary column. This is the value that will be returned in the result set.&quot;

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.

Additional query words: TKBOOK RRBOOK BKOFFICE SQL 0-7356-0673-0

Keywords: kbdocerr kbdocfix kbinfo KB271783

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.