MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008—Implementation and Maintenance comments and corrections

This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation and Maintenance, 978-0-7356-2605-8.

The following topics are covered:

• CD-ROM: Practice test question scored incorrectly
• CD-ROM: Incorrect answers to Readiness Review question
• CD-ROM: Practice test question scored incorrectly
• CD-ROM: Practice test question is incorrect
• Page 6: Instructions for verifying supporting software requirements are partially incorrect
• Page 13: No should be 16
• Page 18: (AI) should be (AS)
• Page 19: Note is incorrect
• Page 21: Incorrect answer to Quick Check
• Page 22: Additional step needed to create another account
• Page 24: Steps 8 and 9 need to be switched
• Page 25: Step 6 is no longer required for sample database installation
• Page 27: Statement regarding multiple instances of SQL Server is incorrect
• Page 27: Lesson Review question needs to be removed
• Page 46: Lesson 2 introduction is a duplicate of the introduction in Lesson 1
• Page 64: Exponents not printed
• Page 203: "1" should be "0"
• Page 203: CONTINUE_PAST_ERROR should be CONTINUE_AFTER_ERROR
• Page 347: "12-11" shoul be "12-13"
• Page 562: Lesson Review question 1 needs to be removed

CD-ROM: Practice test question scored incorrectly

In the practice test included on the Companion CD, one of the questions has the incorrect answer marked correct.

The question reads:
"The Surveys table in the Geology database has four indexes associated with it: Surveys.IndexA, Surveys.IndexB, Surveys.IndexC, and Surveys.IndexD.

You want to rebuild Surveys.IndexC while keeping the Surveys table available to database users who might want to access it.

From the list on the right, select the lines of code to build a statement to meet your needs. Place your selections in the list on the left in the order in which the statement would be executed. Place your selections in the list on the left by clicking the items in the list on the right and clicking the arrow. You can also use the Up and Down buttons to rearrange items in the list on the left. You might not need to use all the items from the list on the right."

The first line of the answer marked correct is:
"ALTER INDEX Surveys.IndexD ON Surveys"

It should be:
"ALTER INDEX Surveys.IndexC ON Surveys"

CD-ROM: Incorrect answers to Readiness Review question

In the practice test included on the Companion CD, one of the questions has several answers included incorrectly.

The question reads:
“Which of the following commands produces a list of SQL Server Agens Jobs that have been cancelled?”

Change:
“sp_help_jobhistory @run_status=5”

To:
“sp_help_jobhistory @run_status=3”

Change:
“sp_help @execution_status=1”

To:
“sp_help_job @execution_status=1”

Change:
“sp_help @execution_status=4”

To:
“sp_help_job @execution_status=4”

CD-ROM: Practice test question scored incorrectly

In the practice test, one of the questions is scored incorrectly. The question begins:
"You are the senior database administrator at Contoso Pharmacuticals. The Research database is critical to the future operation of the company and has very stringent backup and recovery requirements."

The answer marked correct reads:
"Restore the 1:20 P.M. full backup. Restore the 10 P.M. differential backup. Restore all transaction log backups since 1:20 P.M."

It should read:
"Restore the 1:20 P.M. full backup. Restore the 10 P.M. differential backup. Restore all transaction log backups since 10 P.M."

CD-ROM: Practice test question is incorrect

In the practice test included on the Companion CD, one of the questions is incorrect.

Change:
"You need to grant John the ability to create logins but not to assign permissions or reset passwords.

To which fixed server role should you add John?"

To:
"You need to grant John the ability to create logins, assign permissions, and reset passwords.

To which fixed server role should you add John?"

Page 6: Instructions for verifying supporting software requirements are partially incorrect

On page 6, Practice 2 contains instructions on how to verify if you have the appropriate supporting software installed for the book. The instructions are incomplete and need to be corrected.

Change:
"1. Click Start, and then select Control Panel.
2. Double-click Add/Remove Programs.
3. Verify that you have the minimum versions of Windows Internet Explorer and the .NET Framework installed by performing the following steps:
a. Click Start, and then select Run.
b. Enter regedit in the text box.
c. When the Registry Editor opens, browse through the navigation pane to HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess.
4. Verify the MDAC version in the FullInstallVer key."

To:
"1. Click Start, and then select Control Panel.
2. Double-click Add/Remove Programs.
3. If "Microsoft .NET Framework 3.5" appears in the list, your system meets the requirement.
4. Verify you have the minimum version of Windows Internet Explorer by performing the following steps:
a. Click Start, and then select Run.
b. Enter regedit in the text box.
c. When the Registry Editor opens, browse through the navigation pane to HKEY_LOCAL_MACHINE\Software\Microsoft\Internet Explorer.
d. Verify the Internet Explorer version in the Version key.
5. Verify that you have the minimum version MDAC installed by performing the following steps:
a. Click Start, and then select Run.
b. Enter regedit in the text box.
c. When the Registry Editor opens, browse through the navigation pane to HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess.
d. Verify the MDAC version in the FullInstallVer key."

Page 13: No should be 16

On page 13, the Multiple Instances line of Table 1-3 is incorrect.

Change:
To:

Page 18: (AI) should be (AS)

On page 18, the last sentence of paragraph 4 contains an incorrect acronym.

Change:
"For example, if you use the collation sequence of SQL_Latin1_General_CP1_CI_AI, you get support for a Western European character set that is case-insensitive and accent-insensitive. SQL_Latin1_General_CP1_CI_AI treats e, E, è, é, ê, and ë as the same character for sorting and comparison operations, whereas a case-sensitive (CS), accent-sensitive (AI) French collation sequence treats each as a different character."

To:
"For example, if you use the collation sequence of SQL_Latin1_General_CP1_CI_AI, you get support for a Western European character set that is case-insensitive and accent-insensitive. SQL_Latin1_General_CP1_CI_AI treats e, E, è, é, ê, and ë as the same character for sorting and comparison operations, whereas a case-sensitive (CS), accent-sensitive (AS) French collation sequence treats each as a different character."

Page 19: Note is incorrect

On page 19, the NOTE is incorrect and should be disregarded.

Page 21: Incorrect answer to Quick Check

On page 21, Quick Check Answer 1 is incorrect.

Change:
"Only SQL Server Enterprise supports multiple instances on the same machine."

To:
"All editions of SQL Server support multiple instances on the same machine."

Page 22: Additional step needed to create another account

On page 22, Practice 1 requires an additional step after Step 5 to create the SQL2008TK432FullText account.

Add the following line after Step 5:
"6. Repeat steps 3 and 4 to create another account named SQL2008TK432FullText."

Page 24: Steps 8 and 9 need to be switched

On page 24, Steps 8 and 9 at the top of the page need to be switched because in the setup procedure Step 9 comes before Step 8.

Change:
"8. Review the disk space requirements, and then click Next.
9. On the Instance Configuration page, verify that Default Instance is selected and click Next."

To:
"8. On the Instance Configuration page, verify that Default Instance is selected and click Next.
9. Review the disk space requirements, and then click Next."

Page 25: Step 6 is no longer required for sample database installation

On page 25, Step 6 is not required as the current AdventureWorks database installers from the CodePlex website install the database without the need for any additional tasks. This step should be removed and Step 7 should be renumbered to Step 6.

Page 27: Statement regarding multiple instances of SQL Server is incorrect

On page 27, the 4th bullet down from the top is incorrect.

Change:
"SQL Server supports up to 50 instances installed on a single machine; however, only the Enterprise Edition has multi-instance support."

To:
"SQL Server Enterprise supports up to 50 instances installed on a single machine; however, all other editions only support 16."

Page 27: Lesson Review question needs to be removed

On page 27, Lesson 3 Review question 1 includes concepts not convered in the Lesson or Chapter and should be removed.

Page 46: Lesson 2 introduction is a duplicate of the introduction in Lesson 1

On page 46, the paragraph under "Lesson 2: Configuring Database Options" is a duplicate of the introduction in Lesson 1.

Change:
"Data within a database is stored on disk in one or more data files. Prior to being written to the data file(s), every transaction is written to a transaction log file. In this lesson, you learn how to design the data files underneath a database, group the files into filegroups to link physical storage into a database, and manage the transaction log."

To:
"Each database has a variety of configuration options which control the default behavior within the database. Some of the options such as those which control the recoverability of transactions, handling of database pages, and management of statistics apply for the entire database. Other options such as the ability to track changes and how data is sorted and grouped by queries can be overridden at a table or column level. In this lesson, you will learn about the options available for a database and how each option affects database and query behavior."

Page 64: Exponents not printed

On page 64, some of the numbers in Table 3-1 should be printed as exponents, but are not.

Change:
To:

Page 203: "1" should be "0"

On page 203, the 3rd sentence under the Transaction Log Backups heading uses and incorrect integer value.

Change:
"The LSN is an integer value that starts at 1 when the database is created and increments to infinity."

To:
"The LSN is an integer value that starts at 0 when the database is created and increments to infinity."

Page 203: CONTINUE_PAST_ERROR should be CONTINUE_AFTER_ERROR

On page 203, the first sentence is incorrect.

Change:
"To continue past the error and back up as many pages as possible, you can specify the CONTINUE_PAST_ERROR option."

To:
"To continue past the error and back up as many pages as possible, you can specify the CONTINUE_AFTER_ERROR option."

Page 347: "12-11" shoul be "12-13"

On page 347, the first full sentence contains a reference to the wrong figure.

Change:
"If you look very closely at Figure 12-11, startup parameters are separated by a semicolon (;)."

To:
"If you look very closely at Figure 12-13, startup parameters are separated by a semicolon (;)."

Page 562: Lesson Review question 1 needs to be removed

On page 562, the answer to question 1 under Lesson 3 is an answer that hasn't had it's concepts reviewed in the Lesson or Chapter and should be removed.

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.