PART I THE JOB OF THE ORACLE DBA
1 The World of a Database Administrator 2 The Database Administrator’s Job Description3 History and Development of Databases and Oracle 4 Oracle and Its Environment 5 The Tools of the Trade
This book will help you in your endeavor to upgrade your Oracle OCP DBA
certification to the latest level—Oracle Database 11g. It is a study guide for Oracle
Database administrators who plan to take the OCP Oracle Database 10g: New Features
for Administrators Exam Guide (Exam 1Z0-050). This exam is also known commonly
as the DBA “Upgrade” exam because you can upgrade to the latest Oracle Database 11g
OCP certification from the Oracle10g OCP certification. In order to take this exam,
Oracle Corporation must have already certified you as an Oracle10g OCP....
This book is divided into eight major sections.
In Part I, “Critical Database Concepts,” you will see an overview of Oracle Database 11g’s
options, how to install the Oracle software, how to create or upgrade a database, and advice on
planning your application implementation. These chapters establish the common vocabulary that
both end users and developers can use to coherently and intelligently share concepts and ensure
the success of any development effort.
Critical Database Concepts
new features include “invisible” indexes, simplified table maintenance, and editioned objects. You should evaluate your previous architecture decisions in light of the new features available. In the next several chapters, you will see how to install Oracle Database 11g and how to upgrade to Oracle Database 11g from prior releases. Following those chapters, you will see an overview of application planning, followed by many chapters on the use of SQL, PL/SQL, Java, object-oriented features, and XML to get the most out of your Oracle database.
Simple, predictable, flexible, and the most comprehensive support policy available, the
Oracle Lifetime Support Policy helps drive your business success. Oracle’s industry-
leading support policy covers your entire technology environment, from database to
middleware to applications—an industry first, only from Oracle.
Oracle’s Lifetime Support Policy also puts you in control of your upgrade strategy. Our
flexible support policy stages make it easier for you to plan and budget for Oracle’s
exclusive product upgrades.