 MCSE: SQL Server 2000 Design Study Guide: Exam 70-229
ISBN: 978-0-7821-2942-7
Hardcover
832 pages
September 2001
This title is out-of-print and not currently available for purchase from this site.
Other Available Formats: Adobe E-Book
|
Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.
| Chapter | Page | Details | Date | Print Run |
|---|---|---|---|---|
| 31 | error on pg. 31 On page 31, the note "If A is functionally dependent on B, we also say that A is a determinant of B" should instead be "If A is functionally dependent of B, we also say that B is a determinant of A". |
|||
| Combined Errata Page 0 CD Edge Test: Bonus Exam 1. Question #15, correct answer should be "B" not "C"
Page 0CD EdgeTest, Assesment Test, Bonus 2, Question # 41 should be "B." EdgeTest, Assesment Test, Bonus 2, Question # 53. Replace "London" with "city" in the C and D answers. Not in the question.
Page 22 In the last complete para., in the 4th line, mandatory should be "optional"
Page 34* 1st para. under Fig. 1.18,3rd sentence,
Page 68 9th line of code, Listing 2.1, secondary file FILENAME='d:\FakeDB_data2.mdf', should be:FILENAME='d:\FakeDB_data2.ndf',
Page 87 Under Shrinking a File - 2nd line, "if you have a 200MB file" should be "if you have a 100 MB
Page 90 Exercise 2.3, Step 4 - Should read "4. Select the Shrink File To option and type 5 in the text box." and not "4. Select the Shrink File To option and type 80 in the text box."
Page 91 Middle of page, under Warning, "The following example modifies, in one statement, the database name..." should read "The following example modifies, in one statement, the file name..."
Page 92 Under Adding a file - 'd:\FakeDB_data3.mdf'should be 'd:\FakeDB_data3.ndf' (file extension)
Page 94 3rd line of code at the top of the page, ALTER DABASE should be ALTER DATABASE Top of page "sp_rename 'FakeDB', 'TestDB'" should read "sp_renamedb 'FakeDB', 'TestDB'"
Page 106 SGAM section should read "In this result, ALLOCATED means 1 and NOT ALLOCATED means 0 ..."
Page 140 Question 7 Answer B should Read..."Create a new data file on the E drive located on the primary filegroup. The system will then balance new inserts amongst both drives."
Page 144 1st para., 1st line, should be "and observe that the data file..." instead of "...observe the that data...".
Page 154 1st para., 2nd sentence should be "Datatypes are part of domain integrity." instead of "...entity integrity.".
Page 180 Last para., 1st line 'datatypes' should be "datatype" Last para., 2nd line '....multiple byte columns...' should be "....multiple BIT columns ...." Table 3.1, datatype Text, max value should be 2^31-1
Page 187 Under Step #9, 1st para, 1st line should read "Dropping a user-defined datatype is not possible if it is referenced in..."
Page 196 3rd bullet, clarification - "The null block contains the nullability value of every nullable column" should be "The null block contains the nullability value of every column"
Page 200 1st para., last line, 'slot 1' should be "slot 3"
Page 212 Ques. # 8, 9th line, delete the coma at the end of the line.
Page 213 Ques. # 10, Choices "A & B" 2nd line should end with "NOT NULL"
Page 219 Ques. # 8 answer "A" incorrect. Should be "D"
Page 225* 2nd para., within the 'Triggers vs. Constraints' box, 2nd line, 1st word 'after' should be "before"
Page 225 1st para. after 'Triggers vs. Constraints' box should read "...defined at a column..." instead of "...defined at column..."
Page 232 Under Default Object, 2 intances, - sp_binddefault - should be "sp_bindefault"
Page 233 The 1st para. should read "... execute the sp_unbindefault stored..." instead of "...sp_undbindefault..."
Page 236 Last para., 2nd line, two table-level ....., should be "one table-level ...."
Page 274 Question 5 continuation, 3rd available portion of code: "PRIMARY KEY (StudentID" needs a closing parenthesis- should read (StudentID)
Page 284-285 Answer to Review question 5 is missing "CREATE TABLE StudentsCourses"
1. CREATE TABLE Students 2. CREATE TABLE Courses 3. CREATE TABLE StudentsCourses 4. ALTER TABLE StudentsCourses Page 284 Ques. # 5 answer,line 6in box- "PRIMARY KEY (StudentID" needs a closing parenthesis- should read (StudentID)
Page 323 Code snippet under the 2nd paragraph should read: CREATE CLUSTERED INDEX idxOrderID ON [Order Details](Orderid) WITH SORT_IN_TEMPDB
Page 345 Ques. #3 should read "You are a developer ........"
Page 348 Ques. #9 should read "You are a developer ............"
Page 350* Ques. # 11, Choice "B", delete the closed paren. at the end of the answer.
Page 384 First sentence on the page first word 'database' should be 'procedure'.
Page 385 3rd portion of code, 13th line from bottom of page, - "SELECT @test = SUM(..." should be " SELECT @total = SUM(..."
Page 408 Bottom of page, the Select statment is in error, should be "SELECT DATABASEPROPERTYEX('IsRecursiveTriggersEnabled')"
Page 412 Figure 6.6, the deleted table at the bottom of the page should contain a TaskID of 2, not 3.
Page 419 11th and 12th line from the bottom of page, Code - "EXEC sp_settrigerorder" should be " EXEC sp_settriggerorder" (2 g's)
Page 429 Under # 6., "SELECT PersonID" needs to be qualified, as in "SELECT Employees.PersonID"
Page 431 Under # 9, line 9, CORP02 should be "CORP2"
Page 432 Ques. #10 should read "You are working for Southridge Video as a database developer. You ......"
Page 465 5th line from top, should read: GROUP BY c.CustomerID, c.Country (delete 4th line)
Page 473 Subqueries in the FROM Clause, "Ordered" is not a valid Northwind column name; replace with "OrderID"
Page 506 Under SELECT 1 as Tag code, line 3 & 4, The hyphen should not have been inserted.
Page 519 Ques. #1 Choice "D", last line should be, "WITH SUM(..........)"
Page 522 Ques. # 4, answer choice D., 4th line should be "ON c.CustomerID = o.CustomerID"
Page 525-526 In Ques. # 10, and possible answer choices, FROM email_list e, s.state, i.income_bracket should be "FROM email_list e, state s, income_bracket i" in 4 places.
Page 525 Ques. # 9, in all possible answer choices, change ...XMLTemplate2.xml to Samples.xml
Page 664 6th line from the bottom, SP_SETAPP-ROLE should read SP_SETAPPROLE
Page 665 Step 2 should read "......, type the following query to add an application role (be sure...):"
Page 767* Answer for Ques. # 8 should be "B & C". .
Page Objectives Page Under "Alter database objects..........", add 'Resolve replication conflicts'
|
