Oracle DBA Exam Cram: Test 3 and Test 4: Exam: TEST 3 & TEST 4 - Softcover

Softcover

ISBN 10: 1576103315 ISBN 13: 9781576103319

Publisher: Coriolis Group, 1998

Synopsis

Oracle DBA Exam: Test 3 and Test 4 is the only book available to help DBAs improve their chances of becoming certified. Covers all required topics, concepts, and terminology. Helps readers make use of the best study materials available with end-of-chapter resource sections. Features practice exam questions formatted like those encountered on the actual exam. Provides a special tear-out Cram Sheet with tips, acronyms, and memory joggers that readers can review just prior to taking an exam.

About this title

Review

The second pair of tests required for Oracle Certified Professional DBA status measure not only your technical knowledge of Oracle but also your foresight and skill at designing recovery strategies and tuning installations for performance. Oracle DBA Test 3 and Test 4 Exam Cram distills the key information on these database topics to prepare you for the certification tests.

The book begins with an excellent discussion of tuning in which the authors present a structured process to tuning and provide exceptional coverage of the statistics and tracing tools at your disposal. Subsequent chapters examine specific aspects of tuning: database configuration, Shared Global Area (SGA), lock contention, sorting, rollback segments, and redo logs. The amount of information dedicated to these topics is rather cursory, with only the critical material presented.

In the final chapters of the book, backup and recovery topics are discussed in preparation for Exam 4. The discussion begins at a high level, focusing on overall backup plans, and then moves downward into the various backup and recovery mechanisms, including exporting possibilities and recovery scenarios. This section wraps up with a chapter on troubleshooting backups and plucking errors from log files.

At the end of each portion of the book is a sample test that gauges your knowledge, and occasional icons punctuate the text to draw your attention to tips and possible trick questions. Chapter quizzes and a fold-out cram sheet also help keep you on track. Oracle DBA Test 3 and Test 4 Exam Cram is designed as a test preparatory tool, but it also works well as a refresher for database administrators rusty on their tuning and recovery skills. --Stephen Plain

About the Author

Michael R. Ault (Alpharetta, GA) is Chief Technical Officer and part owner of DBMentors, International, Inc., an Oracle consulting and training firm, and was a quality control expert for the OCP exams. Michael is the author of Oracle DBA Exam Cram: Test 1 and Test 2, and the co-author of Oracle DBA Exam Cram: Test 3 and Test 4. His books have been translated into German, Portuguese, and Chinese.

Paul Collins (Fulton, MO) is a senior Oracle consultant for Skyler-Marks Consulting, where he specializes in Oracle database design and administration. He has been a speaker at both Oracle Open World and the IOUG-Alive conferences. Paul was one of the DBAs who worked with Oracle and the Chauncy Group to develop the Oracle 7 Database Administrator certification test. He is Oracle8 certified, and the co-author of Oracle DBA Exam Cram: Test 3 and Test 4with Michael Ault, as well as a contributor on the Oracle DBA Exam Cram: Test 1 and Test 2.

Barbara Ann Pascavage, Chauncey Oracle 7, OCP 7.3, OCP 8.0 (Alexandria, VA) has been working with Oracle since 1987, and has been a full-time Oracle DBA since 1991. She has taught several Oracle SQL and relational database classes. Barbara is currently a Senior Oracle DBA with the Washington Post, and is the co-author of Oracle DBA Exam Cram Test 3 and Test 4with Michael Ault.

Edition details

• Publisher: Coriolis Group
• Publication date: 1998
• ISBN 10: 1576103315
• ISBN 13: 9781576103319
• Binding: Paperback
• Language: English
• Number of pages: 300
• Editor: Ault Michael R.