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

by ; ;
Edition: 1st
Format: Package
Pub. Date: 2009-09-07
Publisher(s): McGraw-Hill Education
List Price: $99.00

Rent Book

Select for Price
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$111.38
*To support the delivery of the digital material to you, a digital delivery fee of $3.99 will be charged on each digital item.
$111.38*

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

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.

Author Biography

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.

.

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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.