OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide
Introducing the Oracle Relational Database System
Introducing the Oracle product family
Interpreting Oracle Database versioning
Understanding the role of the DBA
Examining the tools of the Oracle DBA
Introducing the Companylink database
Installing the Oracle Database Software
Planning an Oracle installation
Reviewing the installation prerequisites
Using the Oracle Universal Installer
Installing the Oracle Database software
Planning for a database creation
Creating an Oracle database using DBCA
Examining a manual database creation
Examining Windows Services in Oracle
Certification objectives covered
Examining the Oracle Architecture
Understanding the Oracle RDBMS
Examining the Oracle database components
Exploring Oracle Real Application Clusters
Certification objectives covered
Managing Oracle Storage Structures
Examining Oracle's physical space paradigm
Using advanced tablespace management techniques
Certification objectives covered
Understanding database startup and shutdown
Setting database initialization parameters
Understanding the data dictionary
Exploring the static data dictionary views
Understanding database diagnostic information
Understanding the Oracle Support model
Understanding the fundamentals of database security
Creating and managing user accounts
Understanding role-based security
Understanding key security parameters
Certification objectives covered
Understanding the lifecycle of a transaction
Managing serialization mechanisms
Certification objectives covered
Understanding Oracle networking concepts
Understanding database registration
Certification objectives covered
Understanding object-level tuning
Managing the Automatic Workload Repository
Understanding Oracle's Advisory Framework
Understanding Oracle Memory Management
Certification objectives covered
Understanding Backup and Recovery Concepts
Understanding the redo-based architecture
Understanding Flash Recovery Area
Understanding instance recovery
Understanding the categories of database failure
Introducing the Data Recovery Advisor
Certification objectives covered
Understanding Oracle Recovery Manager
Performing RMAN offline backups
Certification objectives covered
Understanding the recovery process
Performing RMAN complete recoveries
Performing incomplete recoveries
Using the Data Recovery Advisor
Certification objectives covered
Understanding external data access
Migrating data with Oracle Data Pump
Preparing for the Certification Exam
Preparing for the Certification Exam
Preparing for the Certification Exam