OCA Oracle® Database 11g Administrator Certified Associate Study Guide -- Acknowledgments -- About the Author -- Contents at a Glance -- Contents -- Introduction -- SQL Fundamentals I Assessment Test -- Answers to SQL Fundamentals I Assessment Test -- Administration I Assessment Test -- Answers to Administration I Assessment Test -- Part I: Oracle Database 11g: SQL Fundamentals I -- Chapter 1: Introducing SQL -- SQL Fundamentals -- Writing Simple Queries -- Accepting Values at Runtime -- Summary -- Exam Essentials -- Untitled -- Review Questions -- Answers to Review Questions -- Chapter 2: Using Single-Row Functions -- Single-Row Function Fundamentals -- Using Single-Row Character Functions -- Using Single-Row Numeric Functions -- Using Single-Row Date Functions -- Using Single-Row Conversion Functions -- Using Other Single-Row Functions -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 3: Using Group Functions -- Group-Function Fundamentals -- Utilizing Aggregate Functions -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 4: Using Joins and Subqueries -- Writing Multiple-Table Queries -- Using Set Operators -- Subqueries -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 5: Manipulating Data -- Using DML Statements -- Understanding Transaction Control -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 6: Creating Tables and Constraints -- Database Objects Overview -- Built-in Datatypes -- Creating Tables -- Modifying Tables -- Managing Constraints -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 7: Creating Schema Objects -- Creating and Modifying Views -- Creating and Managing Sequences -- Creating and Managing Synonyms.

Creating and Managing Indexes -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Part II: Oracle Database 11g: Administration I -- Chapter 8: Introducing Oracle Database 11g Components and Architecture -- Oracle Database Fundamentals -- Oracle 11g Architecture -- Installing Oracle 11g -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 9: Creating an Oracle 11g Database -- Using DBCA to Create Oracle 11g Databases -- Working with Oracle 11g Metadata -- Managing Initialization-Parameter Files -- Starting Up and Shutting Down an Oracle Instance -- Monitoring the Database Alert Log -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 10: Allocating Database Storage and Creating Schema Objects -- Tablespaces and Data Files Overview -- Managing Tablespaces -- Managing Data Files -- Working with Schema Objects -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 11: Understanding Network Architecture -- Introducing Network Configurations -- An Overview of Oracle Net Features -- Configuring Oracle Net on the Server -- Configuring Oracle Net for the Client -- An Overview of Oracle Shared Server -- Oracle Shared Server Infrastructure -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 12: Implementing Security and Auditing -- Creating and Managing User Accounts -- Granting and Revoking Privileges -- Controlling Resource Usage by Users -- Auditing Database Activity -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 13: Managing Data and Undo -- Manipulating Data through SQL -- Identifying PL/SQL Objects -- Monitoring Locks and Resolving Lock Conflicts -- Leveraging Undo Management -- Summary -- Exam Essentials -- Review Questions.

Answers to Review Questions -- Chapter 14: Maintaining the Database and Managing Performance -- Proactive Database Maintenance -- Managing Performance -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 15: Implementing Database Backups -- Understanding and Configuring Recovery Components -- Performing Backups -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 16: Recovering the Database -- Understanding Types of Database Failure -- Performing Recovery Operations -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Chapter 17: Moving Data and Using EM Tools -- Understanding Data Pump -- Loading Data with SQL*Loader -- Populating External Tables -- Using EM Support Workbench -- Using EM to Manage Patches -- Summary -- Exam Essentials -- Review Questions -- Answers to Review Questions -- Appendix: About the Companion CD -- What You'll Find on the CD -- System Requirements -- Using the CD -- Troubleshooting -- Glossary -- Index -- 1Z0-051 Exam Objectives -- 1Z0-052 Exam Objectives.