OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 / Edition 1

OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 / Edition 1

by John Watson, Roopesh Ramklass, Bob Bryla
     
 

View All Available Formats & Editions

ISBN-10: 0071629181

ISBN-13: 9780071629188

Pub. Date: 08/17/2009

Publisher: McGraw-Hill Professional Publishing

A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053

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

Overview

A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053

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

On the CD-ROM:

  • Three full practice exams
  • Detailed answers and explanations
  • Score report performance assessment tool
  • Complete electronic book
  • Three bonus exams available with free online registration

Product Details

ISBN-13:
9780071629188
Publisher:
McGraw-Hill Professional Publishing
Publication date:
08/17/2009
Series:
Oracle Press Series
Pages:
1050
Product dimensions:
7.70(w) x 9.20(h) x 2.50(d)

Table of Contents

Part I: Oracle Database 11g Administration

Chapter 1. Architectural Overview of Oracle Database 11g

Chapter 2. Installing and Creating a Database

Chapter 3. Instance Management

Chapter 4. Oracle Networking

Chapter 5. Oracle Storage

Chapter 6. Oracle Security

Part II: SQL

Chapter 7. DDL and Schema Objects

Chapter 8. DML and Concurrency

Chapter 9. Retrieving, Restricting, and Sorting Data Using SQL

Chapter 10. Single-Row and Conversion Functions

Chapter 11. Group Functions

Chapter 12. SQL Joins

Chapter 13. Subqueries and Set Operators

Part III: Advanced Database Administration

Chapter 14. Configuring the Database for Backup and Recovery

Chapter 15. Back Up with RMAN

Chapter 16. Restore and Recover with RMAN

Chapter 17. Advanced RMAN Facilities

Chapter 18. User-Managed Backup, Restore, and Recovery

Chapter 19. Flashback

Chapter 20. Automatic Storage Management

Chapter 21. The Resource Manager

Chapter 22. The Scheduler

Chapter 23. Moving and Reorganizing Data

Chapter 24. The AWR and the Alert System

Chapter 25. Performance Tuning

Chapter 26. Globalization

Chapter 27. The Intelligent Infrastructure

Appendix: About the CD

Glossary

Index

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >