Errata Sheet OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052) By John Watson ISBN 0-07-159102-8 Errata as of 03/12/2009 Page 176, chapter 5, exercise 5-2, step 8: "scope=spfile" should read "scope=memory." Page 428: the query on the last line should read "systimestamp - 10/1440", not "systimestamp - 1/1440." Page 429: "... there ten minutes ago." The SQL on page 428 is for 1 minute, the description on page 429 says 10. CD errata: Quiz A, question 37: The correct answer is C, not B. Even though the statement that created it was "select * from ..." this is re-written as "select employee_id, first_name, ...." by the creation process. You can check this with "select text from user_views where view_name= .... ". Therefore the view will not become invalid when another column is added to the table, but it will not show the new column. Errata as of 11/16/2009 Page 295, Step 2, 3rd line: “create user afra..” should not have a semicolon at the end of it (i.e. it should be like the previous statement). Page 303, step 2: “grant create sessions to alois;” should be “grant create session to alois”. Page 339 in the table in seems like there should be a line separating REORGANIZE and RUN SEGMENT ADVISOR. These seem to be two separate actions. Page 337, Figure 9-4: Screenshot is the wrong version; the last statement in the screenshot should have 2 rows retuned. There is a quote missing following 23-04-05. Page 343, 3rd paragraph: “…in which can all the rows where the key columns…” should say “…in which case…” Page 343, 4th paragraph: “The structure these indexes…” should say “The structure of these indexes…” Page 344, 1st paragraph: “…as discussed in the previous section Creating Tables”. The DEFAULT clause and how it pertains to columns was not discussed in the section Creating Tables. The DEFAULT clause isn't mentioned, and perhaps should be. This is covered in the SQL Fundamentals book and the OCA/OCP All-In-One. Page 394, on-the-job hint: the definition for argument and parameter are backwards. An argument is a specific instance of a parameter. The text should be corrected to reverse the usage of the terms. Page 403, 2nd paragraph from the bottom, first sentence: “…but this one case where even…” should be “…but this is one case where even…” Page 405 last paragraph in the INSIDE THE EXAM box: “This is a means whereby sessions lock rows as they affected by DML statements”. Should this maybe be “…are affected by DML statements”? Page 421, First line: “…Oracle does a better job that you ever could”. Should be “…Oracle does a better job than you ever could.” Page 426, Figure 11-3: second create statement is missing a RETENTION GUARANTEE at the end. The figure is demonstrating this feature. Page 426, 1st paragraph: “…undo tablespace can altered later to enable it.” Should be “…undo tablespace can be altered later to enable it.” Page 472, last line: “…However, you…” I think should be “…Therefore, you…” Page 433, Certification Summary Section, last sentence in first paragraph: “…though this may mean that transaction fail.” Should be “…though this may mean that transactions fail.” Thanks to the following readers who submitted errata: Brad Potts (thanks Brad!) Earl Shaffer Nik Eichler