Book Errata

Teradata 12 Certification Study Guide - Basics

Correction #1:
Chapter 3 -
Practice questions are as follows:
• #5 should be A not C
• #6 should be C not A
Status: Corrected in 2nd printing

Correction #2:
Chapter 5 -
• Typo on Page 79:
Line #5 should be "each lock varies in its abilities and priorities" not "each lock varies in it abilities and priorities"
Status: Corrected in 2nd printing

Correction #3:
Chapter 7 -
• Stored Procedure in Figure 7.6 is incorrect. It should be:
CREATE PROCEDURE DeleteCustomer (IN inCust INTEGER, OUT msg VARCHAR(20)) BEGIN DELETE FROM customer WHERE cust_id = :inCust; SET msg = 'Delete Completed'; END;

• Stored Procedure call in Figure 7.7 is incorrect. It should be:
CALL DeleteCustomer (100, msg);
CALL DeleteCustomer (200, msg);
Status: Corrected in 2nd printing

Correction #4:
Chapter 9
• Typo on Page  134:
TDWM description "Manager and monitor workload strategies" should read "Manages and monitors workload strategies"
Status: Corrected in 2nd printing

Correction #5:
Chapter 9 -
• Practice Question #3:
Question should read as:
"Which of the following items can be tracked by the Database Query Log (DBQL) (Choose all that apply)?"
Status: Corrected in 2nd printing

Teradata 12 Certification Study Guide - SQL

Correction #1:
Chapter 2 -
Practice questions are as follows:
• #3 Answer C should read:
WHERE (A = 1) OR (B = 2) AND (C = 3) OR (D = 4)
Status: To be corrected in subsequent printing

Correction #2:
Chapter 3 -
• Under "HELP TABLE" - Text states Figure 3.4, but should be Figure 3.5. Then it states Figure 3.5, but should be Figure 3.6. “The HELP command in Figure 3.4 returns…” “The chart in Figure 3.5 returns…”
Status: To be corrected in subsequent printing

Correction #3:
Chapter 3 -
• Under "SHOW TABLE" - Text states Figure 3.4, but should be Figure 3.5. “The … command to the HELP command in Figure 3.4.”
Status: To be corrected in subsequent printing

Correction #4:
Chapter 4 -
• Under "Extracting Portions of Dates" - Text “shown below” should be “Figure 4.13”.
Status: To be corrected in subsequent printing

Correction #5:
Chapter 8 -
• Paragraph starts with “To”, but should be “The”.
Status: To be corrected in subsequent printing

Correction #6:
Chapter 10 -
• Above figure 10.8, second sentence:
"It uses the ASC to reverse the default sequence of DESC"
- SHOULD READ -
"It uses the ASC to reverse the sequence of DESC"
Status: To be corrected in subsequent printing