Print this page Share

OCA: Oracle 10g Administration I Study Guide: Exam 1Z0-042

ISBN: 978-0-7821-4367-6
672 pages
December 2004
OCA: Oracle 10g Administration I Study Guide: Exam 1Z0-042 (0782143679) cover image


Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years, this book provides:
  • Clear and concise information on database administration with Oracle 10g
  • Practical examples and insights drawn from the authors' real-world experiences
  • Leading-edge exam preparation software, including a test engine and electronic flashcards

You'll also find authoritative coverage of key exam topics, including:

  • Installing Oracle Database 10g Software
  • Creating and Controlling Oracle Databases
  • Administering Users
  • Managing Schema Objects and Data
  • Implementing Oracle Security Features
  • Monitoring Performance
  • Performing Database Backup and Recovery

Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace

See More

Table of Contents


Assessment Test.

Chapter 1: Oracle Database 10g Components and Architecture.

Chapter 2: Creating and Controlling a Database.

Chapter 3: Database Storage and Schema Objects.

Chapter 4: Oracle Net Services.

Chapter 5: Oracle Shared Server.

Chapter 6: User Administration and Security.

Chapter 7: Managing Data With SQL, PL/SQL, and Utilities.

Chapter 8: Managing Consistency and Concurrency.

Chapter 9: Proactive Database Maintenance and Performance Monitoring.

Chapter 10: Implementing Database Backups.

Chapter 11: Implementing Database Recovery.



See More

Author Information

Chip Dawes, OCP, is a consultant with D&D Technologies and presents at various Oracle User Group conferences.

Matthew Weishan, OCP, is a senior specialist for EDS in Madison, Wisconsin.

Joseph C. Johnson, OCP, has over 8 years of experience in the management of Oracle databases, and is currently working as a Senior Database Administrator.

Bob Bryla, OCP, currently works as an Oracle DBA and Analyst for Lands' End.

See More


Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
Combined Errata

Page 24

In the NOTE- "hostname:5550" should be changed to "hostname:5500".

Page 53

In the statement,"On windows systems, you can create
the PFILE in the
%ORACLE_BASE%\admin\PROD\pfile directory and then put
another PFILE in %ORACLE_HOME%\dbs etc"

should be modified to
"put another PFILE in %ORACLE_HOME%\database etc"

Page 141

second NOTE, the word "system" should be changed to "SYSTEM" (fixed font).

Page 167

The first complete CREATE TABLE statement should instead be:
CREATE TABLE employees
(employee_id NUMBER NOT NULL
,hire_date DATE NOT NULL
,first_name VARCHAR2(42)
,last_name VARCHAR2(42)
,payroll_id VARCHAR2(10)
CONSTRAINT uniq_payroll_id UNIQUE

Page 211

In Table 4.2
The two entries of Table 4.2 on page 211 in the first column "Save Configuration On Shutdown" and "Unavailable from Net Manager" should be swapped. Also, to make the table more understandable, "Unavailable from Net Manager" should be changed to "(Unavailable from Net Manager)" to make it clear that this entry does not have a prompt in Net Manager.

Page 214

In the second paragraph on page 214, "select the listener" should be replaced with "select Listeners".

Page 216

On page 216, first paragraph, change "You will then see the new listener listed in the listener control screen" to "You will then see the new listener listed on the Listeners screen".

Page 226

(FAILOVER=ON) is needed in the tsnnames.ora file for connect-time failover just after ADDRESS_LIST=

Page 278

Table 5.1-Caption, "DISPATCHER" should be changed to "DISPATCHERS".

Page 325

The create role statement "CREATE ROLE app1-dba;"
should be replaced with "CREATE ROLE

app1_dba IDENTIFIED BY seekwrit;", because the role is
enabled with a SET ROLE statement which

has a IDENTIFIED BY clause in the statement,"SET ROLE
app1_dba IDENTIFIED BY seekwrit;".

Yes, while the two statements at the top of page 325 will technically not generate a syntax error, the IDENTIFIED BY in the second statement is not validated if the role itself does not have a password. Therefore, the first statement "CREATE ROLE appl_dba;" should be replaced with "CREATE ROLE appl_dba IDENTIFIED BY seekwrit;".

Page 360

line #8 of the INSERT FIRST statement should be changed from..
line #8 of the INSERT FIRST statement should be changed from "INTO property_premium_fact(policy_id" to "INTO casualty_premium_fact(policy_id".

Page 367

In the line,"Events can be created on DML events, DLL events..." 'DLL' should be replaced with 'DDL'.

Page 390

In table 7.7, "aata" should instead be "data".

Page 413

On the last line of page 413,
On the last line of page 413, "UR * UPS" should instead be "UR * UPS * DB_BLOCK_SIZE"

Page 415

Second paragraph: "This parameter is not available as an initialization parameter. Unlike most every other command or procedure in the database, it is not available via the EM Database Control; you must use ALTER TABLESPACE at the command line to set it, as in the following example:" is incorrect
Replace this text with:
"This parameter is not available as an initialization parameter, instead, it is an attribute of the undo tablespace itself. You can change it using EM Database Control or you can use ALTER TABLESPACE at the command line to set it, as in the following example:"

Page 470

Three errors in the third paragraph of the text box at the top of page 470:
- "(1 + Warning %/100)" should be changed to "(1 - Warning Percentage/100)" (two errors fixed here, one for consistency with the wording earlier on the page)
- "or 15, raising" should be changed to "or 15MB, raising"
- "below 15 percent." should be changed to "below 15MB."

Page 472

The last sentence of the second paragraph should read "Background process trace files are found in the directory specified by the BACKGROUND_DUMP_DEST parameter, and the user process trace files are found in the directory specified by the USER_DUMP_DEST parameter. Both of these parameters are defined in the PFILE or SPFILE."

Page 477

In the statement,"Using the Indexes screen...recompile
indexes..", should be replaced with "Using

the Indexes screen... rebuild indexes..". Indexes are

The screen reference is correct; in Figure 9.55 we're only showing that the index is unusable at this point, and fixing the index later.

However, in the first paragraph on page 477, "JOBS_ID_PK" should be changed to "JOB_ID_PK".

See More

Learn more about

Back to Top