Description
Oracle 10g: Database Administrator: Implementation and Administration (DBA1) uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator. This real-world approach, combined with topics ranging from initialization parameters and table space storage to data integrity, constraints, and user profiles, provides good preparation for the update Oracle certification exam, Database Fundamentals I (#1Z0-041). In addition to extensive review material, the end of chapter content also includes comprehensive coverage of the exam objectives and exam-like practice questions.
1. Oracle Architecture Overview
2. Tools and Architecture
3. Creating an Oracle Instance
4. Oracle Physical Architecture and Data Dictionary Views
5. Basic Storage Concepts and Settings
6. The Basics of Querying a Database
7. Basic Table Management
8. Advanced Table Management
9. Constraints, Indexes, and Other Specialized Objects
10. Basic Data Management
11. Advanced Data Management
12. Security Management
13. Performance Monitoring
14. Proactive Maintenance
15. Backup and Recovery