OCP Oracle Database 11g Administrator Certified Professional Study Guide

895 Pages·2009·12.11 MB·English

Prepare for OCP certifi cation
in Oracle Database 11g OCP Covers All Exam Objectives
FEATURED ON THE CD
Study, practice, and review for Oracle Certifi ed Professional
STUDY GUIDE
certifi cation in Oracle 11g, Oracle’s new release of its top-selling
database software. Inside this in-depth guide, you’ll fi nd full Includes Real-World Scenarios, Over 100 Additional Pages of
coverage of essential topics for the very latest, updated Admin- A O Hands-On Exercises, and Leading-Edge Exam Prep Software
istration II exam (1Z0-053), including database architecture and Featuring:
d
r
ASM; confi guring backups; using Flashback technology; managing
m a
database performance, memory, and resources; and more. c (cid:127) Custom Test Engine
Get extra exam practice using the exercise workbook in the in le
(cid:127) Hundreds of Sample Questions
Appendix. Start your preparation today with: i ®
s
t D (cid:127) Electronic Flashcards for PCs, Pocket PCs,
r
Full coverage of all exam objectives in a systematic approach, so you
a a and Palm Handhelds
can be confi dent you’re getting the instruction you need for the exam t t
SYBEX TEST ENGINE: o a
(cid:127) Entire Book in PDF
Bonus Exercise Workbook that allows you to practice as you learn Test your knowledge with advanced r b
Real-world scenarios that put what you’ve learned in the context testing software. Includes all chapter C a
review questions and bonus exams. s OCP
of actual job roles e e
r
Challenging review questions in each chapter to prepare you for t 1
i 1
exam day fi
g
e

Exam Essentials, a key feature in each chapter that identifi es critical d
areas you must become profi cient in before taking the exam
P
A handy tear card that maps every offi cial exam objective to the r
o
corresponding chapter in the book, so you can track your exam prep
f
objective by objective ELECTRONIC FLASHCARDS: e
Reinforce your understanding with s
Oracle Database 11g
fl ashcards that can run on your PC, s ®
Look inside for complete coverage Pocket PC, or Palm handheld. i
o
n
of all exam objectives.
a Administrator Certified
Also on the CD, you’ll fi nd the entire
l
www.sybex.com book in searchable and printable PDF.
ABOUT THE AUTHORS Study anywhere, any time, and Freeman
approach the exam with confi dence.
Professional
Robert G. Freeman, OCA, OCP, is a principle database engineer at the Church of Jesus Pack
Christ of Latter-Day Saints. He has written 12 books on a variety of Oracle topics and is a Stuns
frequent speaker at Oracle conferences across the country. Charles A. Pack, OCP, has
Buterbaugh STUDY GUIDE
over 20 years of IT experience. He is currently the Technical Director of Hardware Provi- CATEGORY
sioning at CSX Technology, where he and his teams are responsible for enterprise storage, COMPUTERS/Certifi cation Guides
backups, capacity planning, and performance. Doug Stuns, OCP, has over 14 years of
experience as an Oracle DBA, developer, and trainer. Tim Buterbaugh, OCP, is a DBA ISBN: 978-0-470-39513-4 Exam 1Z0-053
with over 17 years’ experience. He currently works as a consultant with EDS. Exam 1Z0-053 Robert G. Freeman
Charles A. Pack
Doug Stuns
$69.99 US
SERIOUS SKILLS.
$83.99 CN Tim Buterbaugh
95134flast.indd 29 1/28/09 9:30:03 AM
OCP
Oracle® Database 11g
Administrator Certified
Professional
Study Guide
95134ffirs.indd 1 1/27/09 4:00:06 PM
95134ffirs.indd 2 1/27/09 4:00:06 PM
OCP
Oracle® Database 11g
Administrator Certified
Professional
Study Guide
Robert G. Freeman
Charles A. Pack
Doug Stuns
Tim Buterbaugh
95134ffirs.indd 3 1/27/09 4:00:07 PM
Acquisitions Editor: Jeff Kellum
Development Editor: Kim Wimpsett
Technical Editors: Arup Nanda and Bob Bryla
Production Editor: Christine O’Connor
Copy Editor: Judy Flynn
Production Manager: Tim Tate
Vice President and Executive Group Publisher: Richard Swadley
Vice President and Publisher: Neil Edde
Assistant Project Manager: Jenny Swisher
Associate Producer: Angie Denny
Quality Assurance: Josh Frank
Book Designer: Judy Fung, Bill Gibson
Compositor: Craig Woods, Happenstance Type-O-Rama
Proofreader: Candace English
Indexer: Nancy Guenther
Project Coordinator, Cover: Lynsey Stanford
Cover Designer: Ryan Sneed
Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
ISBN: 978-0-470-39513-4
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form
or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as
permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior
written permission of the Publisher, or authorization through payment of the appropriate per-copy fee
to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, [phone], fax
[phone]. Requests to the Publisher for permission should be addressed to the Permissions
Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax
[phone], or online at http://www.wiley.com/go/permissions.
Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or war-
ranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all
warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be
created or extended by sales or promotional materials. The advice and strategies contained herein may not
be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in
rendering legal, accounting, or other professional services. If professional assistance is required, the services
of a competent professional person should be sought. Neither the publisher nor the author shall be liable for
damages arising herefrom. The fact that an organization or Web site is referred to in this work as a citation
and/or a potential source of further information does not mean that the author or the publisher endorses the
information the organization or Web site may provide or recommendations it may make. Further, readers
should be aware that Internet Web sites listed in this work may have changed or disappeared between when
this work was written and when it is read.
For general information on our other products and services or to obtain technical support, please contact
our Customer Care Department within the U.S. at [phone], outside the U.S. at [phone] or
fax [phone].
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may
not be available in electronic books.
Library of Congress Cataloging-in-Publication Data is available from the publisher.
TRADEMARKS: Wiley, the Wiley logo, and the Sybex logo are trademarks or registered trademarks of
John Wiley & Sons, Inc. and/or its affiliates, in theUnited Statesand other countries, and may not be used
without written permission. Oracle is a registered trademark of Oracle Corporation. All other trademarks
are the property of their respective owners. Wiley Publishing, Inc., is not associated with any product or
vendor mentioned in this book.
10 9 8 7 6 5 4 3 2 1
95134ffirs.indd 4 1/27/09 4:00:07 PM
Dear Reader,
Thank you for choosing OCP: Oracle Database 11g Administrator Certified Professional
Study Guide. This book is part of a family of premium-quality Sybex books, all of which are
written by outstanding authors who combine practical experience with a gift for teaching.
Sybex was founded in 1976. More than thirty years later, we’re still committed to pro-
ducing consistently exceptional books. With each of our titles we’re working hard to set
a new standard for the industry. From the paper we print on, to the authors we work
with, our goal is to bring you the best books available.
I hope you see all that reflected in these pages. I’d be very interested to hear your comments
and get your feedback on how we’re doing. Feel free to let me know what you think about
this or any other Sybex book by sending me an email at [email protected], or if you think
you’ve found a technical error in this book, please visit http://sybex.custhelp.com.
Customer feedback is critical to our efforts at Sybex.
Best regards,

Neil Edde
Vice President and Publisher
Sybex, an Imprint of Wiley
95134ffirs.indd 5 1/27/09 4:00:07 PM
This book is dedicated to my wife, Lisa; my children; and my father.
—Robert G. Freeman
For my wife, Donna, and our daughter, Jenny.
—Charles A. Pack
95134ffirs.indd 6 1/27/09 4:00:07 PM
Acknowledgments
Writing a book is such a vast undertaking that it’s hard to know where to start with the
acknowledgments. I also hate writing this part because, frankly, someone always gets for-
gotten. That being said, here we go.
Thanks to my patient wife, Lisa, who sits across from me in our office and typically gets
as little sleep as I do. Thanks to my kids who are still managing to grow up into wonderful
adults in spite of this crazy world. Thanks to all my great friends at work who support me,
who uplift me (imagine working at a job where you can start a meeting with a prayer!), and
who are some very smart people. In particular, thanks to David Wright, Bill Johnson, Heber
Allen, Jed Brunson, Dan Dredge, and Mandy Cosper. Additional thanks to Dave Prestwich,
Mike Bowers, Stephen Shaffer, Brent Moody, and John Harper. Thanks also to my Core
team guys Scott Black, Dennis Carlson, Ryan Allen, and Randy Knight. Also thanks to my
way cool DBE team members Curt Workman, Bill Francis, Mike Noble, Ben Beishline, and
Matthew Newman. You are all awesome. Thanks also to the rest of the EIM team at the
church; you are awesome but too numerous to mention in the space I have here. I’ve worked
with more awesome people that I can list in these pages. If I could list all your names here, I
would. As it is, just know that I appreciate you and loved working with you over the years.
Writing books is a long, complex, and often frustrating task. Thanks to all the folks at
Sybex that participated in the making of this book. Thanks to Jeff Kellum, who was my
acquisitions editor, for getting me involved in this project. I’d worked with Jeff before on my
very first book, and apparently he didn’t remember the pain I caused him well enough, since
he asked me to write this book anyway. Thanks to Kim Wimpsett for awesome editing and
being the best development editor ever! Thanks to Christine O’Connor for doing a bang-up
job with the book and to Judy Flynn, copy editor extraordinaire, the proofreader Candace
English, and to Nancy Guenther, indexer.
Finally, a very important thanks goes out to YOU. Thanks for buying this book. Thanks
for wanting to become an Oracle Certified Professional. Thanks for any nice comments you
might leave on websites here and there. Thanks for trusting us to help you succeed at the test!
—Robert G. Freeman
Thanks to Robert Freeman and Jeff Kellum for the opportunity to write this book. Thanks to
David May, Gary Baird, and Greg Sinclair for providing a rock-solid infrastructure, not only
in which to practice my art but also to the great benefit of my employer, CSX. Thanks to my
capacity management team Chris Roessler, Harry Price, Brian Horan, Jan Shane, Joe Zuleger,
and Derryck Zimmerman; my storage team Andy Brackett, Scott Gunter, Joe Fredrickson,
Mike Able, John Anderson, Chris Griffith, Rick Ferry, Gene Pate, and Jim Gouvernante. To
my coworkers Benny Kronz, Maritza Gonzalez, Chris Wilson, John Kall, Sandra Merwin,
Duard Williams, Rich McClain, and Frank Lamon, for building a world-class Oracle data-
base environment at CSX and for making it possible for me to continuously learn, develop,
and teach.
95134ffirs.indd 7 1/27/09 4:00:07 PM
viii Acknowledgments
This book would not have been written without my wife’s permission, of course. Thank
you, Donna, for being by my side through these projects, especially during the summer
months in Florida. Thank you to my daughter, Jenny, who is 7 and sitting next to me on
the sofa writing stories on her MacBook about Chihuahuas and leopard geckos while I
write about “the Oracle.”
—Charles A. Pack
95134ffirs.indd 8 1/27/09 4:00:07 PM