Chapter1 Oracle9i New Features for Administrators.
Chapter2 Oracle Overview and Architecture.
Chapter3 Installing and Managing Oracle.
Chapter4 Creating a Database and Data Dictionary.
Chapter5 Control and Redo Log Files.
Chapter6 Logical and Physical Database Structures.
Chapter7 Segments and Storage Structures.
Chapter8 Managing Tables, Indexes, and Constraints.
Chapter9 Managing Users, Security, and Globalization Support.
|Download Images Used in the Book|
Download a .zip file with the images from the book.
To uncompress the file, Windows users can use Windows built-in ZIP utilities or a 3rd party utility like WinZip or WinRAR. Macintosh users can simply double-click the downloaded file to extract using the built-in archive utility.
Page 0 CD
Bonus Exam #2,
The question reads:
Objective Test - Creating a Database:4. B. The CREATE DATABASE command succeeds, and sets all log files to a size of 5M, including the log file that already exists. If a particular log file does not exist, the REUSE clause is ignored and a new file with a size of 5M. If a file already exists, you MUST specify REUSE.
The Tip on Page 40 should read: "...but cannot be dynamically altered".
- Authors Note regarding "DISTRIBUTED_TRANSACTIONS"
In any case, the Oracle instance will still start successfully, and under 9.2, the number of current distributed transactions is unlimited.
Items 3 and 4 on page 57 should be reversed.Once the integrity of the data is maintained (by writing the data to the redo log file along with the SCN), the user will be notified (for example, by returning to the SQL*Plus prompt) that the transaction is complete.
question 3, the number of database writer processes (DBWn)Â allowed in Oracle 9.2Â now has a maximum of 20. However, in version 9.0 of Oracle (the release under which the book was written), the maximum was still 10.
Table 3.1 Data Type "VARCHAR2 (8)" should read "VARCHAR2 (16)"
Table 3.1 Purpose line 3 "SYS_MODIFIED" should read "SYSTEM_MOD"
see detailed description
The REUSE clause overwrites an existing file, if any, provided the sizes are the same.
The REUSE clause overwrites an existing file, if any, and applies the new size, if specified; if SIZE is not specified, the original size is retained. REUSE must be used if the file already exists, otherwise an error is returned."
Point 4b - 'catproc.sql' calls this one. This should be indented as part of an expanded '4a', detailing what else that 'catproc' runs.
Pont 4c - 'otrcsvr' is from previous Oracle releases. The new script is 'dbmsotrc.sql', and it is run by the installer.
Replace the answer to question 4 to:
Right before the heading "Creating New Control Files", add a "Note" (from the Sybex Word Template) which reads: The initialization parameter DB_CREATE_ONLINE_LOG_DEST_n is used to create both control files and online redo logs.
3. Lines 2 and 3 "/ora01/" needs to be changed to "/ora04/" - only one line should be modified..we are copying from "ora01"Â toÂ "ora04" adding a 4th copy of the control file
Under the section that starts with LOG_ARCHIVE_DEST_n, 2nd line, 'five' should read "ten"
1st line under V$ARCHIVE_DEST '... about the five archive destinations,...' should be '... about the ten archive destinations,...'
Chapter 5, Question 2 Change option C. from "Tablespace names" to "Datafile names."
ALTER DATABASE ADD LOGFILE
Question 19 '...key step in multiplexing redo log files...'should be '...key step in multiplexing control files...'
Line 6 has an extra ";". The ";" after "100M" should be removed.
The para. immediately above the TIP in the middle of the page, last sentence should be changed.
"You cannot use the ALTER TABLESPACE statement to change a locally managed temporary tablespace to a locally managed permanent tablespace. The following statement changes a dictionary managed permanent tablespace to temporary:
2nd paragraph from the bottom, last sentence should read: You can place a tablespace back online by using the statement ALTER TABLESPACE USER_DATA ONLINE.
Middle of the page "V$_TABLESPACE" should be "V$TABLESPACE"
The CREATE DATABASE command on page 217 should be replaced with the following:
Middle of page, 4. Bring the tablespace online., 1st sentence under the line of code should read "If more than one tablespace needs its files moved or renamed, or if a file belonging to the SYSTEM tablespace must be moved or renamed, follow these steps:"
The answer to question #2 should read "Undo segment" instead of "Rollback segment" to be more consistent with the answer provided.
Table 8.1, last line of VARCHAR2, by default the size is in 'bytes' vs. "characters"
Bottom of page, last partition 'FY2000Q3' should be "FY2002Q3"
Middle of page, the last partition 'DOC203' should be "DOC204"
Middle of page, the last partition 'M2001' should be "M9999"
The beginning of the second paragraph on p. 288 should change from "Storage for temporary tablespace is" to "Storage for temporary tables is".
ALTER TABLE statement,
ALTER TABLE ORDERS ALLOCATE EXTENT (SIZE 200K);
Similarly, the fourth ALTER TABLE statement on page 289 should read
ALTER TABLE ORDERS ALLOCATE EXTENT (SIZE 200K
4th line in # 4, should be FROM CHAINED_ROWS
Analyzing Indexes - All the three "ALTER INDEX...." statements should read "ANALYZE INDEX..."
Under the second bullet point (text starting "Use CREATE TABLE to define constraints..."), the Oracle statement has two errors in the line "PRODUCT_ID)": see detailed description
On the second line, the second occurrence of "DISABLED" should instead be "DISABLE".
The SELECT statement at the top of the page should read:
Question 1 option C should be 1200KB not 12000KB.
DBA role contains the system privileges GRANT ANY PRIVILEGE, GRANT ANY OBJECT PRIVILEGE, and GRANT ANY ROLE, the text is incorrect -- it should read instead: "Unless you have the DBA role or the system privilege GRANT ANY OBJECT PRIVILEGE, to grant privileges on objects owned by another user you must have been granted the appropriate privilege on the object WITH GRANT OPTION."
"DELETE_CATALOG_ROLE Ability to drop or re-create the dictionary packages"
Exam 1Z1-031 should read Exam 1Z0-031