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,
Should read:
"For example, the pub_name or the city is repeated". Au_id and Title_id columns form the primary key. 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"
In the answer, you should have:
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
The default is a nonclustered index, you need to specify clustered. 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". .
After 1st sentence of explanation, add
Alternatively you can include the HASH option in the JOIN specification. Page Objectives Page
Under "Alter database objects..........", add 'Resolve replication conflicts'
|
