DescriptionHere's the book you need to prepare for Exam 1Z0-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide
- In-depth coverage of official exam objectives
- Practical information on implementing and managing Oracle9i databases
- Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including:
- Understanding Oracle architecture and its main components
- Identifying DBA administrative tools
- Setting up password file authentications
- Creating and managing Initialization Parameter Files
- Configuring OMF
- Create a database using Oracle Database Configuration Assistant
- Creating a database manually
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
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