• Sign In
  • My Cart 0)
main product photo

OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM

1st Edition
0071629211 · 9780071629218
A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II exam with help fro… Read More
Add to Wish List
US$89.10
Request Review Copy
Download file to PC or Mac desktops or laptops

Step 1. Download Adobe Digital Editions Both PC and Mac users will need to download Adobe Digital Editions to access their eBook. You can download Adobe Digital Editions at Adobe's website here.


Step 2. Register an Adobe ID if you do not already have one. (This step is optional, but allows you to open the file on multiple devices) Visit account.Adobe.com to register your Adobe account.


Step 3: Authorize Adobe Digital Editions using your Adobe ID. In Adobe Digital Editions, go to the Help menu. Choose “Authorize Computer.”


Step 4: Open your file with Adobe Digital Editions. Once you’ve linked your Adobe Digital Editions with your Adobe ID, you should be able to access your eBook on any device which supports Adobe Digital Editions and is authorized with your ID. If your eBook does not open in Adobe Digital Editions upon download, please contact customer service

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

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