Errata Sheet
OCP Oracle Database 11g: New Features for Administrators Exam Guide (Exam 1Z0-050)
By Sam Alapati
ISBN 0-07-149682-3
p11: Bullet 6: The initialization parameter ddl_time_lockout should read ddl_lock_timeout.
p17 At the bottom of the page, the explanations for the parameters PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME should be switched.
p32: On Line 1, catupgd.sql should read catupgrd.sql
P43: In the paragraph after the third wrc example, the text says: "The mode parameter is the only required parameter”. This is true only if you want to specify the CALIBRATE or LIST_HOSTS mode. If you want to choose REPLAY as the mode parameter value, you don't have to explicitly specify this, as REPLAY is the default value for the MODE parameter
p58 In the last piece of code, Line 1, there’s a dot (.) missing after dbms_sqlpa. The line should read: select dbms_sqlpa.report_analysis_task (task_name =>
p59. In the very first line of the page, test_execute should read test execute
P61. At the bottom of the page, EXECUTE_ANALYSIS_TASK should read REPORT_ANALYSIS_TASK.
p61. At the end of the first paragraph, SQL baselines should read SQL plan baselines.
p61. In EXERCISE 1-3, in steps 5 and 7, test_execute should read "test execute".
P61. In EXERCISE 1-3, in step 9, compare_performance should read "compare performance".
p63 The bullet: The default ADR base directory IS $ORACLE_BASE/diag should read as follows:
The default ADR base directory IS $ORACLE_BASE (if ORACLE_BASE isn't set, the directory would default to $ORACLE_HOME/diag).
p72 In the explanation for the incorrect answers for Question 2, Oracle Configuration should read Oracle Configuration Manager
p87. After adrci script=adrci.txt, it should read as follows: 
 The script shown here will run the set homepath and show alert commands.
P93 At the bottom of the page, the heading "Adding Logical Information to a Logical Package" should read "Adding Diagnostic Information to a Logical Package"
P136. Please change the first line to:
You must first generate a physical package before finalizing it.
P137: Under the section titled Data Recovery Advisor, the fifth bullet has the following error:
Validate or backup command ...should read Validate or backup validate command...
p143 Answer 7: A is listed as the correct answer. The correct answer is D.
Page 149: The last bullet in the page, DROP_BASELINE_TEMPLATE lets you drop an AWR baseline should read:
DROP_BASELINE_TEMPLATE lets you drop an AWR baseline template
p151 In the last line of the first paragraph, "start and snapshotidentifiers... “ should read “start and end snapshot identifiers...”
p153 At the top of the page, replace the two lines of code with the following:
baseline_name => ‘peak_baseline’,) 
RETURN awr_baseline_metric_type_table PIPELINED;
end;
p161 In the Enabling a Maintenance task section, at the end of the first paragraph, operation_name should read operation
p173: In the last paragraph, line 5: "in an RAC..." should read “in a RAC..."
p177. In Step 4, under the code, first paragraph, second line: TEST_PROG<> should read TEST_PROG.
p192. In the Exam Watch, DBMS_NETWORK.ASSIGN_ACL should read DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL
p224: In the SQL code at the bottom of the page, execution_) name should read execution_name
p229. In the SQL code under Step 2, "open baseline_cursor for" should read "open test_cursor1 for"
p231: First paragraph under the section Selecting SQL Plan Baselines contains an error. Please replace the paragraph with the following:
Once you collect the SQL plans either from the AWR or from the cursor cache, the next step is to ensure that the use of the SQL plan baselines is enabled. The initialization parameter optimizer_use_sql_plan_baselines controls the use of the SQL plan baselines by the database. The parameter is set to TRUE by default, meaning that the use of the SQL plan baselines by the optimizer is enabled by default...
p233: Please REPLACE 
SQL> exec dbms_spm.evolve_sql_plan_baseline (sql_handle=>'123456789999'); 
with the following:
 SET SERVEROUTPUT ON 
SET LONG 10000 
DECLARE 
report clob; 
BEGIN 
report:= DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE( 
sql_handle => '123456789999'); 

DBMS_OUTPUT.PUT_LINE(report); 
END; 
/ 
p237. In the On the Job bullet: A job ...should read A SQL plan...
P244. IN the SQL code at the bottom of the page, line 4:  "open mycursoror" should read "open mycursoror"
P247: The sentence after the first line of code should begin with Once rather than One.
p265 The first sentence at the top of the page should read: 
The database divides each ASM disk into allocation units (AU), which are the...
p266	At the bottom of the page, Step 1 mentions the "after disk group" command: this should be "alter diskgroup". Step 1 shows a sample command which "instructs the database not to wait to drop the database": it should read: "instructs the database not to wait to drop the disk. 
P266 Last paragraph: The phrase "ASM rebalances the list mirrored extents" should read: “ASM rebalances the mirrored extents”.
p267	The first sentence in the final paragraph reads: "The value of the disk_repair_time attribute in this example is set to 6h, which means two hours". This is incorrect: it should be "2h" instead of "6h", as shown in the actual example.
P268: In the last two code examples, failuregroups should read failgroup
p268	The last line reads as following:

This command requires the database to wait for two hours before bringing the disk group dgroupA online again.

The sentence should read as following instead:

This command requires the database to wait for the disk group to be rebalanced before bringing the disk group dgroupA online again.

p270	The second bullet point reads: For 3-way mirroring, choose a “high disk group type": the content within the quotes should refer to a "high redundancy level".
p270	The second paragraph contains the sentence: "A normal redundancy disk group requires a minimum of two disk groups...". This should be "...a minimum of two failure groups...”
p270 Paragraph 3 contains an occurrence of "failgroup"--this should be failure group instead
p271 The first paragraph in the "Using Enterprise Manager" section refers to a "Preferred Read Failures Group" field. This should be the "Preferred Read Failure Groups" field.
p272 The first paragraph in the "ASM Scalability and Performance Enhancements" section states "You can set variable size extents with extents of size 1, 4, 16, 32, and 64 megabytes." "The ability to set variable-size ASM extents..." This should refer to allocation units (AU), not extents. The AU size is determined at the disk group creation time with the AU_SIZE disk group attribute. The available AU sizes are 1, 2, 4, 8, 16, 32, and 64 MB. The extent sizes are equal to the AU size, or multiples of 8 or 64 of the AU size, as shown here:
Number of Extents
Size
0 - 19999
1*AU
20000 - 39999
8*AU
40000 - 59999
64*AU

p274 The last paragraph refers to the "SYASM" privilege. This should be the "SYSASM" privilege.
p277 The second code example contains 2 errors. The semi-colon at the end of line 2 should be removed. The attribute name in line 3 should be 'compatible.rdbms', not 'rdbms.asm'.
p280  The second paragraph states that: "For an 11g ASM instance, the default ASM compatibility is 11.1...The default ASM compatibility is 10.1.
p282 After Step 5,
“Note the following when you mount a disk group in the mount mode:” should read
“Note the following when you mount a disk group in the restrict mode:”
p285 After the On the Job bullet, the sentence: You can also attach the –l flag … should read You can also attach the I command …
p285 The command:
ASMCMD> lsdsk –lk  should read ASMCMD> lsdsk -lI
p286 Last paragraph, line 2: /tmp/dbbackup07022 should read /tmp/asmbkp1.
P287. In the three md_restore command examples, please note that backup_file at the end of the command should be actually –b backup_file. In the second example, there’s a –g missing before asmdks1.
p290 In the second paragraph, Line 3, change interval to range 
p297 Change partitioned enhanced to partition enhanced
P302 Line 1 at the top of the page: "partitioning the key" should read "partitioning key".
p307 Line 1 at the top of the page: ORDER_ITEMS column should be ORDER_ID column
p328 Line 8: max_memory_target should read memory_max_target
p345 In the DBMS_STATS.GATHER_TABLE_STATS example: In the last Line of the code, please replace "skewonly" with "size skewonly"
p346 In the DBMS_STATS.GATHER_TABLE_STATS example: In the last Line of the code, please replace “skewonly" with "size skewonly"
p367 In the Inside the Exam box, DBMS_STATS.PUBLISH-PENDING_STATS should read DBMS_STATS.PUBLISH_PENDING_STATS
p384 Second from last line: perform the backup should read perform the duplication
p397 In Step 3, Line 1: name should read names
p425. In the first paragraph after the first SQL code example, as_of should read as of.
P432 In line 3, nonconflict_only should read noconflict_only


Thanks to the following readers who submitted errata:

Alistair Greieve, S.Francis (Kingwood, Texas), W.Ma, Johnny Grimes