OCA/OCP Oracle Database 11g All-in-One Exam Guide: (Exam 1Z0-051, 1Z0-052, and 1Z0-053)
- 18h 38m
- Bob Bryla, John Watson, Roopesh Ramklass
- Oracle Press
- 2010
Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exams 1Z0-051, 1Z0-052, and 1Z0-053, including:
- Instance management
- Networking and storage
- Security
- SQL
- Oracle Recovery Manager and Oracle Flashback
- Oracle Automatic Storage Management
- Resource manager
- Oracle Scheduler
- Automatic workload repository
- Performance tuning
- And more
About the Authors
John Watson, OCP, is a consultant with BLP Management Consultants. He taught for Oracle University in South Africa.
Roopesh Ramklass, OCP, is a technical specialist with 10 years of experience.
Bob Bryla, OCP, has been working with databases for more than 15 years.
In this Book
-
Architectural Overview of Oracle Database 11g
-
Installing and Creating a Database
-
Instance Management
-
Oracle Networking
-
Oracle Storage
-
Oracle Security
-
DDL and Schema Objects
-
DML and Concurrency
-
Retrieving, Restricting, and Sorting Data Using SQL
-
Single-Row and Conversion Functions
-
Group Functions
-
SQL Joins
-
Subqueries and Set Operators
-
Configuring the Database for Backup and Recovery
-
Back Up with RMAN
-
Restore and Recover with RMAN
-
Advanced RMAN Facilities
-
User-Managed Backup, Restore, and Recovery
-
Flashback
-
Automatic Storage Management
-
The Resource Manager
-
The Scheduler
-
Moving and Reorganizing Data
-
The AWR and the Alert System
-
Performance Tuning
-
Globalization
-
The Intelligent Infrastructure