OCA: Oracle 10g Administration I Study Guide (1Z0-042) [Paperback]

Chip Dawes (Author), Bob Bryla (Author), Joseph C. Johnson (Author), Matthew Weishan (Author)

Book Description

Publication Date: December 24, 2004 | ISBN-10: 0782143679 | ISBN-13: 978-0782143676

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

Editorial Reviews

From the Back Cover

Here's the book you need to prepare for the Oracle Database 10gAdministration I exam, 1Z0-042. This Study Guide was developed tomeet the exacting requirements of today's Oracle certification candidates. Inaddition to the consistent and accessible instructional approach that has earnedSybex the "Best Study Guide" selection in CertCities Readers ChoiceAwards for two consecutive years, this book provides:

Clear and concise information on database administration withOracle 10g

Practical examples and insights drawn from the authors' real-worldexperiences

Leading-edge exam preparation software, including a test engineand electronic flashcards
You'll also find authoritative coverage ofkey exam topics, including:

• Installing Oracle Database 10gSoftware
• Creating and Controlling Oracle Databases
• AdministeringUsers
• Managing Schema Objects and Data
• Implementing Oracle SecurityFeatures
• Monitoring Performance
• Performing Database Backup andRecovery

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

About the Author

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.

Product Details

• Paperback: 672 pages
• Publisher: Sybex (December 24, 2004)
• Language: English
• ISBN-10: 0782143679
• ISBN-13: 978-0782143676
• Product Dimensions: 9 x 7.4 x 1.6 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 3.6 out of 5 stars  See all reviews (15 customer reviews)
• Amazon Best Sellers Rank: #222,696 in Books (See Top 100 in Books)
  • #30 in Books > Computers & Technology > Databases > Relational Databases

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

13 of 14 people found the following review helpful:

3.0 out of 5 stars Good to give you the basics but the test has changed, September 4, 2007

By 

Aebares2006 (Boston, MA) - See all my reviews

This review is from: OCA: Oracle 10g Administration I Study Guide (1Z0-042) (Paperback)

I used this book to study for the OCA test for a month and thought I would pass with my SQL & limited Oracle experience. I did not pass the test because the test has changed to Senario Driven with Multiple Choice & Multiple answers. You would receive a long paragraph about a user's needs. You would need to select two answers out of five; 1 would be easy to pick, 2 would seem wrong and 2 would seem almost identical and right. That is where the test has gotten harder.

Where this book gives you the foundation of all the "What's" involved, the test needs the "Whys".

I recommend SELFTEST software Oracle pushes on thier site. I find the questions and style are very similar to what I had experienced.

I still recommend this book if would like to understand the concepts and have an oracle DB at your disposal
If you then need or want the cert buy the selftest software because I'm positive half of my questions came from that product. By spending your money on both of those products you will still make out very well because the Live course for this subject is around $2,500.

My experience with Oracle has been from the Healthcare IT environment where the database is already set up and just needs tuneing and Reports. If you are an Oracle Finanicials person you may only need the SelfTest software to practice from.

6 of 7 people found the following review helpful:

4.0 out of 5 stars good if you have oracle preknowledge, May 25, 2006

By 

jensen (indonesia) - See all my reviews

This review is from: OCA: Oracle 10g Administration I Study Guide (1Z0-042) (Paperback)

this is the first book i read to prepare for my OCA exam. at first i was a bit overwhelmed because the chapters are quite long and the languages are not very easy to understand (sometimes i have to reread a sentence two or three times before it clicks). but i guess it was also because by then oracle was still rather new for me. if you are an experienced dba (maybe a 9i oca or ocp) then i guess this book alone should be enough to get you a 10g oca. but if you are new to oracle, i would suggest you to study John & Damir book first (OCP All-in-one exam prep guide), it's easier to absorb and the chapters are shorter (although there are more chapters). then, if you still have the time (and the money) get this book to wrap up your preparation for the oca. i'm sure you will pass the exam like i did.

7 of 9 people found the following review helpful:

4.0 out of 5 stars Book is good enough to get you 50% of marks, February 3, 2006

By 

S. vandanam (Houston,TX) - See all my reviews
(REAL NAME)   

This review is from: OCA: Oracle 10g Administration I Study Guide (1Z0-042) (Paperback)

I cleared my OCA exam with help of sybex and selftest software..could get 73/75 . I would recommend to go for selftest(65% of questions came from selftest in the actual exam) along with sybex..just reading sybex might not be of much help.