Roger E. Sanders
MC Press Online, LP
Lewisville, TX 75077
EXAM 730-IBM Certified Database Associate for DB2 9
Covers all the objectives for the DB2 9 Fundamentals exam, including XML data and XQuery expressions
Contains 100 sample questions plus a 150-question practice exam, all with comprehensive answers and explanations
Written by a member of the DB2 9 Fundamentals certification development team
First Printing-May 2007
© 2007 Roger Sanders.
All rights reserved.
Every attempt has been made to provide correct information. However, the pulisher and the author do not guarantee the accuracy of the book and do not assume responsibility for information included in or omitted from it.
The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both: DB2, Lotus, Tivoli, WebSphere, Rational, IBM, the IBM logo, and IBM Press. Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of the Microsoft Corporation in the United States, other countries, or both. Linux is a registered trademark of Linus Torvalds. Intel, Intel Inside (logo), MMX, and Pentium are trademarks of Intel Corporation in the United States, other countries, or both. OSF/1 and UNIX are registered trademarks and The Open Group is a trademark of the The Open Group in the United States and other countries. Other company, product, or service names mentioned herein may be trademarks or service marks their respective owners.
Printed in Canada. All rights reserved. Thie publication is protected by copyright, and permission mut be obtained from the publisher prior to any prohibited reporduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recordsing, or likewise.
MC Press offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales, which may include custom covers and content particular to your business, training goals, marketing focus, and branding interest.
For information regarding permissions or special orders, please contact:
MC Press
Corporate Offices
125 N. Woodland Trail
Lewisville, TX 75077 USA
For information regarding sales and/or customer service, please contact:
MC Press
P.O. Box 4300
Big Sandy, TX 75755-4300 USA
Dedication
To a good friend who has always been there when I needed him, Rev. Ross Marion
Acknowledgments
A project of this magnitude requires both a great deal of time and the support of many different individuals. I would like to express my gratitude to the following people for their contributions:
Susan Dykman-Information Management Certification Program Manager, IBM Information Management
Susan invited me to participate in the DB2 9 exam development process, and provided me with screen shots of the IBM Certification Exam Testing software. Susan also reviewed the first chapter of the book and provided valuable feedback.
Susan Visser-IBM Press, Data Management Program Manager IBM Toronto Lab
Once again, Susan's help was invaluable-without her help, this book would not have been written. Susan paved the way for me to acquire the rights to the Version 8.1 manuscript and move to MC Press when Pearson Education decided not to publish an updated version of my Version 8.1 book.
Dr. Arvind Krishna-Vice President, IBM Data Servers and Worldwide Information Management Development
Dr. Krishna provided me with the Foreword for this book.
Brant Davison-Program Director, IBM Information Management Software
Brant worked with Dr. Ambuj Goyal, Dr. Arvind Krishna, and me to ensure that IBM received the materials they needed to write the Foreword, and to make sure I received the Foreword for this book in a timely manner.
Rick Swagerman-Senior Technical Manager, DB2 SQL and Catalog Development IBM Toronto Lab
Rick provided me with detailed examples illustrating how the UPDATE/DELETE NO ACTION and UPDATE/DELETE RESTRICT rules of referential constraints work. His examples were converted into some of the illustrations you see in Chapter 6, and Rick reviewed the final draft of many of these drawings for accuracy and completeness.
I would also like to thank my wife, Beth, for her help and encouragement, and for once again overlooking all of the things that did not get done while I worked on yet another book.
About the Author
Roger E. Sanders is the President of Roger Sanders Enterprises, Inc. He has been designing and developing database applications for more than 20 years and has been working with DB2 and its predecessors since it was first introduced on the IBM PC (as part of OS/2 Extended Edition). He has written articles for publications such as Certification Magazine and IDUG Solutions Journal, authored tutorials for IBM's developerWorks Web site, presented at numerous International DB2 User's Group (IDUG) and Regional DB2 User's Group (RUG) conferences, taught classes on DB2 fundamentals and database administration (DB2 for Linux, UNIX, and Windows), writes a regular column (Distributed DBA) in DB2 Magazine, and is the author of the following books:
Using the IBM System Storage N Series with Databases (IBM RedBook; co-author)
Integrating IBM DB2 with the IBM System Storage N Series (IBM RedBook; co-author)
Using IBM DB2UDB with IBM System Storage N Series (IBM RedBook; co-author)
DB2 Universal Database V8.1 Certification Exam 703 Study Guide
DB2 Universal Database V8.1 Certification Exam 701 and 706 Study Guide
DB2 Universal Database V8.1 Certification Exam 700 Study Guide
DB2 UDB Exploitation of NAS Technology (IBM RedBook; co-author)
All-In-One DB2 Administration Exam Guide
DB2 Universal Database SQL Developer's Guide
DB2 Universal Database API Developer's Guide
DB2 Universal Database Call Level Interface Developer's Guide
ODBC 3.5 Developer's Guide
The Developer's Handbook to DB2 for Common Servers
In addition, Roger holds the following professional certifications:
IBM Certified Database Administrator-DB2 9 DBA for Linux, UNIX, and Windows
IBM Certified Database Associate-DB2 9 Fundamentals
IBM Certified Advanced Database Administrator-DB2 Universal Database V8.1 for Linux, UNIX, and Windows
IBM Certified Database Administrator-DB2 Universal Database V8.1 for Linux, UNIX, and Windows
IBM Certified Developer-DB2 Universal Database V8.1 Family
IBM Certified Database Associate-DB2 Universal Database V8.1 Family
IBM Certified Advanced Technical Expert-DB2 for Clusters
IBM Certified Solutions Expert-DB2 UDB V7.1 Database Administration for UNIX, Windows, and OS/2
IBM Certified Solutions Expert-DB2 UDB V6.1 Application Development for UNIX, Windows, and OS/2
IBM Certified Specialist-DB2 UDB V6/V7 User