Preface -- 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 -- Appendix A -- Glossary -- Index.
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.