Errata Sheet
OCA/OCP Oracle Database 11g All-in-One Exam Guide (Exams 1Z0-051, 1Z0-052, 1Z0-053)
By, John Watson, Roopesh Ramklass
ISBN 0-07-16291-81

Errata as of 12-OCT-2010

Page 174: In the following sentence, the term segment is used instead of the term extent in one place. Instead of:
          "An extent can be identified from either the dimension of the segment...the dimension of the datafile (every segment is in one file", starting at a certain Oracle block number)."
          it should be:
          "An extent can be identified from either the dimension of the segment...the dimension of the datafile (every extent is in one file", starting at a certain Oracle block number)."

Page 263: To complete Exercise 7-1, please follow the instructions outlined on page 379 in Chapter 9 to create the HR schema, if it is absent from your database.

Page 271: The insert statements in step 5 must include a value for JOIN_DATE due to the NOT NULL column constraint and should read as:
          insert into customers (customer_id, join_date, customer_status, customer_name, creditrating)
          values (1, sysdate, 'NEW', 'Ameetha', 'Platinum');
          insert into customers (customer_id, join_date, customer_status, customer_name, creditrating)
          values (2, sysdate, 'NEW', 'Coda', 'Bronze');

Page 277: The second sentence in the TIP should read: "If neither of these is the case, then the index is in need of a rebuild."

Page 379: If the hr_main.sql script is missing from your ORACLE_HOME/demo/schema/human_resources directory, then it may be found on the Oracle Database 11g Examples companion CD, downloadable from OTN.

Page 397: In the section "Equality and Inequality" there is an error in the discussion of the algorithm used for the numeric evaluation of character strings.
          In the paragraph following the example "select last_name from employees where last_name < 'King';" which begins with:
          "The character literal 'King'..." and ends with "then the row is selected", please replace with the following sentences:
          "The character literal 'King' is converted to a numeric representation. Assuming a 
           US7ASCII database character set with AMERICAN NLS settings, the literal 'King' is 
           converted into its ordinal character values: K + i + n + g = (75+105+110+103).
           For each row in the EMPLOYEES table, the LAST_NAME column data is similarly 
           converted into numeric values for each character which are then compared in turn 
           with the numeric values of the characters in the literal 'King'. For example,
           the row with LAST_NAME='Kaufling' is compared as follows: The first character in 
           both strings is 'K' with an ordinal value of 75. So the second character (i=105) is 
           compared with (a=97). Since (97 < 105) or (a < i), 'Kaufling' < 'King' and the row
           is selected."



Thanks to the following readers for submitting errata:

Jim King
Chris Hines
Roman Churakov
Claudia Camargo