ISBN 9780070498938,Oracle : Oca Oracle 9I Associate Dba Certification Exam Guide (With Cd-Rom)

Oracle : Oca Oracle 9I Associate Dba Certification Exam Guide (With Cd-Rom)



Tata McGraw - Hill Education

Publication Year 2002

ISBN 9780070498938

ISBN-10 0070498938


Number of Pages 1044 Pages
Language (English)

Computer programming

Full Coverage of Exams 1Z0-007 & 1Z0-031 Prepare for Certification with Authoritative Exam Prep Material from Oracle Press Prepare for the Oracle Certified Associate DBA exams by using this comprehensive Oracle Press study guide. Throughout each chapter, you'll find in-depth details on the material covered in these challenging exams, followed by practice questions and chapter summaries to highlight what you've learned. From the exclusive publisher of Oracle Press books, this package is the most comprehensive preparation tool available for the OCA exams. 100% complete coverage of all official exam objectives Exercises at the end of all discussions that reinforce your Oracle knowledge right away Tips, examples, and reviews in every chapter to help you remember key concepts Two-minute drills--quick and concise checklists that summarize each chapter's main points Chapter self-tests--exam-based questions complete with in-depth explanations More than 600 practice questions--including scenario-based questions

Table of Contents :- 

PART I: Preparing for OCA DBA Exam 1: Introduction to SQL
Chapter 1: Overview of Oracle Databases
Chapter 2: Limiting, Sorting, and Manipulating Return Data
Chapter 3: Advanced Data Selection in Oracle
Chapter 4: Subqueries
Chapter 5: Creating Oracle Database Objects
Chapter 6: Manipulating Oracle Data
Chapter 7: Creating Other Database Objects in Oracle
Chapter 8: User Access Control in Oracle
PART II: OCA Oracle9i SQL Practice Exams
Chapter 9: OCA Exam 1: Introduction to SQL
PART III: Preparing for OCA Database Administration Fundamentals I Exam
Chapter 10: Basics of the Oracle Database Architecture
Chapter 11: Managing the Physical Database Structure
Chapter 12: Managing Tablespaces and Datafiles
Chapter 13: Storage Structures and Undo Data
Chapter 14: Managing Database Objects
Chapter 15: Managing Database Users
PART IV: OCA Oracle9i DBA Fundamentals I Practice Exams
Chapter 16: OCA Database Administration Fundamentals I
Chapter Appendix A: Globalization Support