Errata Sheet
OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051)
By, John Watson, Roopesh Ramklass
ISBN 0-07-15978-67

Errata as of 12/01/2008


Please note: The phrase "OCP examination" encompasses the "OCA examination" and is used synonymously throughout the text.


Page 33: "SQQ" should read "SQL" (in "On The Job" section) 


Page 158, Bullet 5: should read "... a term falls between (and including) given start and end..."


Page 178: result of query 3 should be all lower case. "The" ---> "the"


Page 188: "3.14 approximates pi." should be "3.14 is pi"

Page 200: Sentence "If the divisor is zero...returns zero instead." should be "If the divisor is zero, no division by zero error is returned and the MOD function returns the dividend instead."

Page 307:  Answer 10  "...having SUM(salary)>400 clause.." should be "...having SUM(NVL(salary,100))>400..."


Page 444, Question 12: "Choose three correct answers." should be "Choose the best answer."


Page 484, Lab Answer: "constraint tel_telno_ck check (telno between 1000000 and 9999999)" should read "constraint tel_telno_ck check (telno between 2000000 and 3999999)"



Errors in "Master Exam" from CD (Quiz A for OCA):


Question 56: "If a table has indexes defined...". The correct answer is "D," but the test engine incorrectly scores the answer as "A,B,C."


Question 61: "create view emp_sales are select ...." "Are" should be replaced with "as"  
 

Errors in "Bonus Master Exam" download (Quiz B for OCA):

Question  7: "From the following SELECT...". Right answer is "C," but test engine incorrectly scores correct answer as "D."


Question 15: "Which of following statements..." Answer "C" should be 'select last_name "&last_name" from employees;'


Question 21: Remember that year 2008 was leap year.


Question 39: First answer option is incorrectly disabled. "A" is the correct answer.


Question 40: First answer option is incorrectly disabled. "A" is the correct answer.


Question 41: First answer option is incorrectly disabled. "A" is the correct answer.


Question 43: Exhibit is missing. Using the exhibit referenced in Question 41, answer "C" is clearly correct. Without an exhibit that shows the columns in each table, "A" could technically also result in a Cartesian join.



Thanks to the following readers for submitting errata:

Jussi Jääskeläinen