OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Osborne ORACLE Press Series)

1073 Pages·2009·3.67 MB·English

by  Patricia Ann Potter

®
OCA /OCP
Oracle Database 11g
A ll-in-One
Exam Guide
(Exam 1Z0-051, 1Z0-052, and 1Z0-053)
McGraw-Hill is an independent entity from Oracle Corporation. This
publication and CD may be used in assisting students to prepare for the
OCA exams 1Z0-051 and 1Z0-052, and the OCP exam 1Z0-053. Neither
Oracle Corporation nor The McGraw-Hill Companies warrant that use of
this publication will ensure passing the relevant exam.
About the Authors
John Watson (Oxford, UK) works for BPLC Management Consultants, teaching
and consulting throughout Europe and Africa. He was with Oracle University for
several years in South Africa, and before that worked for a number of companies,
government departments, and NGOs in England and Europe. He is OCP
qualified in both database and application server administration. John is the
author of several books and numerous articles on technology and has 25 years
of experience in IT.
Roopesh Ramklass (South Africa), OCP, is an Oracle specialist who has
worked in a range of contexts. He was part of Oracle’s Support team and taught
at Oracle University in South Africa for many years. As an independent consultant
and manager of his own consulting business, he designed and developed software
and training courses based on a wide spectrum of Oracle technologies., including
the database, application server, and business intelligence products. Roopesh is a
co-author of the OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Oracle
Press, 2008) and has more than 12 years of experience in the IT industry.
About the Technical Editors
Gavin Powell (Cartersville, GA) is a consultant and technical writer with 20 years
of experience in the IT industry. He has worked as a programmer, developer,
analyst, data modeler, and database administrator in numerous industries.
Bruce Swart (South Africa) works for 2Cana Solutions and has over 14 years
of experience in IT. While maintaining a keen interest for teaching others, he has
performed several roles, including developer, analyst, team leader, administrator,
project manager, consultant, and lecturer. He is OCP qualified in both database
and developer roles. He has taught at Oracle University in South Africa for several
years and has also spoken at numerous local Oracle User Group conferences. His
passion is helping others achieve greatness.
April Wells (Austin, TX) is an experienced Oracle DBA who holds multiple
DBA OCP certifications. She currently manages Oracle databases and Oracle data
warehouses at NetSpend corporation in Austin, Texas. Previously, April has worked
for Oracle Corporation in Austin, Texas, as on-site support at Dell, at Corporate
Systems in Amarillo, Texas, and at U.S. Steel in Pennsylvania and Minnesota.
OCA /OCP
Oracle Database 11g
All-in-One
Exam Guide
(Exam 1Z0-051, 1Z0-052, and 1Z0-053)
John Watson
Roopesh Ramklass
New York • Chicago • San Francisco • Lisbon
London • Madrid • Mexico City • Milan • New Delhi
San Juan • Seoul • Singapore • Sydney • Toronto
Copyright © 2010 by The McGraw-Hill Companies, Inc. All rights reserved. Except as permitted under the United States Copyright Act of 1976,
no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the
prior written permission of the publisher.
ISBN: 978-0-07-162921-8
MHID: 0-07-162921-1
The material in this eBook also appears in the print version of this title: ISBN: 978-0-07-162918-8, MHID: 0-07-162918-1.
All trademarks are trademarks of their respective owners. Rather than put a trademark symbol after every occurrence of a trademarked name, we
use names in an editorial fashion only, and to the benefit of the trademark owner, with no intention of infringement of the trademark. Where such
designations appear in this book, they have been printed with initial caps.
McGraw-Hill eBooks are available at special quantity discounts to use as premiums and sales promotions, or for use in corporate training programs.
To contact a representative please e-mail us at
GET
YOU R FREE SUBSCRIPTION
TO ORACLE MAGAZINE
Oracle Magazine is essential gear for today’s information technology professionals.
Stay informed and increase your productivity with every issue of Oracle Magazine.
Inside each free bimonthly issue you’ll get:
t 6 QUPEBUFJOGPSNBUJPOPO0SBDMF%BUBCBTF
0SBDMF"QQMJDBUJPO4FSWFS
8FCEFWFMPQNFOU
FOUFSQSJTFHSJEDPNQVUJOH
EBUBCBTFUFDIOPMPHZ
BOECVTJOFTTUSFOET
t 5IJSEQBSUZOFXTBOEBOOPVODFNFOUT
t 5 FDIOJDBMBSUJDMFTPO0SBDMFBOEQBSUOFSQSPEVDUT
UFDIOPMPHJFT
BOEPQFSBUJOHFOWJSPONFOUT
t %FWFMPQNFOUBOEBENJOJTUSBUJPOUJQT
t 3FBMXPSMEDVTUPNFSTUPSJFT
If there are other Oracle users at
your location who would like to
receive their own subscription to Three easy ways to subscribe:
Oracle Magazine, please photo-
copy this form and pass it along.
1 Web
7JTJUPVS8FCTJUFBU oracle.com/oraclemagazine
:PVMMGJOEBTVCTDSJQUJPOGPSNUIFSF
QMVTNVDINPSF
2 Fax
$PNQMFUFUIFRVFTUJPOOBJSFPOUIFCBDLPGUIJTDBSE
BOEGBYUIFRVFTUJPOOBJSFTJEFPOMZUP+1.847.763.9638
3 Mail
$PNQMFUFUIFRVFTUJPOOBJSFPOUIFCBDLPGUIJTDBSE
BOENBJMJUUP P.O. Box 1263, Skokie, IL 60076-8263
Copyright © 2008, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Want your own FREE subscription?
To receive a free subscription to Oracle Magazine, you must fill out the entire card, sign it, and date
it (incomplete cards cannot be processed or acknowledged). You can also fax your application to
+1.847.763.9638. Or subscribe at our Web site at oracle.com/oraclemagazine
Yes, please send me a FREE subscription Oracle Magazine. No.
From time to time, Oracle Publishing allows our partners
exclusive access to our e-mail addresses for special promo-
x
tions and announcements. To be included in this program,
please check this circle. If you do not wish to be included, you s i g n a t u r e ( r e q u i r e d ) d a t e
will only receive notices about your subscription via e-mail.
n a m e t i t l e
Oracle Publishing allows sharing of our postal mailing list with
selected third parties. If you prefer your mailing address not to c o m p a n y e - m a i l a d d r e s s
be included in this program, please check this circle.
CIf uastt oanmye tri mSe ryvoicue waot u+ld1. 8li4k7e. 7t6o3 b.9e6 3re5m oorv esden fdro man eeit-hmear iml taoil inogra