OCA Oracle Database 11g SQL Fundamentals I Exam Guide P1

There are several Oracle certification tracks—this book is concerned with theOracle Database Administration certification track, specifically for release 11g of thedatabase. There are three levels of DBA certification: Certified Associate (OCA),Certified Professional (OCP), and Certified Master (OCM). The OCA qualificationis based on two examinations, the first of which is covered in this book. The OCPqualification requires passing a third examination
Nội dung trích xuất từ tài liệu:
OCA Oracle Database 11g SQL Fundamentals I Exam Guide P1 ®OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051)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 independent Oracle specialist with over 10 years of experience in a wide variety of IT environments. These include software design and development, systems analysis, courseware development, and lecturing. He has worked for Oracle Support and taught at Oracle University in South Africa for several years. Roopesh is experienced in managing and executing IT development projects, including infrastructure systems provisioning, software development, and systems integration.About the Technical Editor Bruce Swart (South Africa) works for 2Cana Solutions and has over 14 years of experience in IT. Whilst 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.Copyright © 2008 by The McGraw-Hill Companies, Inc. Click here for terms of use. ® OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051) John Watson Roopesh RamklassThis publication and CD may be used in assisting students to prepare for the OCPOracle Database 11g: SQL Fundamentals I exam. Neither Oracle Corporation norThe McGraw-Hill Companies warrant that use of this publication and CD will ensurepassing the relevant exam. New York Chicago San Francisco Lisbon London Madrid Mexico City Milan New Delhi San Juan Seoul Singapore Sydney TorontoCopyright © 2008 by The McGraw-Hill Companies, Inc. All rights reserved. Manufactured in the United States of America. Except aspermitted under the United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form orby any means, or stored in a database or retrieval system, without the prior written permission of the publisher.0-07-164380-XThe material in this eBook also appears in the print version of this title: 0-07-159786-7.All trademarks are trademarks of their respective owners. Rather than put a trademark symbol after every occurrence of a trademarkedname, we use names in an editorial fashion only, and to the benefit of the trademark owner, with no intention of infringement of thetrademark. 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 corporatetraining programs. For more information, please contact George Hoare, Special Sales, at george_hoare@mcgraw-hill.com or (212)904-4069.TERMS OF USEThis is a copyrighted work and The McGraw-Hill Companies, Inc. (“McGraw-Hill”) and its licensors reserve all rights in and to thework. Use of this work is subject to these terms. Except as permitted under the Copyright Act of 1976 and the right to store and retrieveone copy of the work, you may not decompile, disassemble, reverse engineer, reproduce, modify, create derivative works based upon,transmit, distribute, disseminate, sell, publish or sublicense the work or any part of it without McGraw-Hill’s prior consent. You may usethe work for your own noncommercial and personal use; any other use of the work is strictly prohibited. Your right to use the wor ...