OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063)

OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063)

2.75 (4 ratings by Goodreads)
By (author)  , By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 3 business days
When will my order arrive?


This Oracle Press certification exam guide prepares you for the new Oracle Database 12c certification track, including the core requirements for OCA and OCP certification.
OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) covers all of the exam objectives on the Installation and Administration, SQL Fundamentals, and Advanced Administration exams in detail. Each chapter includes examples, practice questions, Inside the Exam sections highlighting key exam topics, a chapter summary, and a two-minute drill to reinforce essential knowledge. 300+ practice exam questions match the format, topics, and difficulty of the real exam. Electronic content includes interactive practice exam software with hundreds of questions that include detailed answers and explanations, a score report performance assessment tool, and a PDF copy of the book
Ideal as both exam guide and on-the-job reference
The most comprehensive single preparation tool for the Oracle Database 12c OCA and OCP certification exams
show more

Product details

  • Book | 1072 pages
  • 150 x 210 x 22mm | 788g
  • McGraw-Hill Education - Europe
  • MCGRAW-HILL Professional
  • United States
  • English
  • 2nd edition
  • 0071828087
  • 9780071828086
  • 319,562

About John Watson

John Watson, OCP (Oxford, UK) is a senior consultant with BLP management Consultants, and taught for Oracle University in South Africa for four years.
Roopesh Ramklass, OCM (Canada) is a technical specialist with 10 years of experience in a wide variety of IT environments, including software development, system administration, systems analysis, software design, systems architecture, courseware development, and lecturing.
Bob Bryla, OCP (Dodgville, WI) has more than 20 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Oracle DBA and database systems engineer at Epic in Verona, Wisconsin.
show more

Table of contents

Part I: Getting Started
Chapter 1: Installing Oracle Database Software
Chapter 2: Creating an Oracle Database Using DBCA
Chapter 3: Installing Oracle Grid Infrastructure for a Standalone Server
Chapter 4: Using Oracle Restart
Part II: SQL
Chapter 5: DDL and Schema Objects
Chapter 6: DML and Concurrency
Chapter 7: Retrieving, Restricting and Sorting Data Using SQL
Chapter 8: Single Row and Conversion Functions
Chapter 9: Group Functions
Chapter 10: SQL Joins
Chapter 11: Subqueries and Set Operators
Part III: DBA1
Chapter 12: Exploring the Oracle Database Architecture
Chapter 13: Managing the Database Instance
Chapter 14: Oracle Networking
Chapter 15: Oracle Storage
Chapter 16: Oracle Security
Chapter 17: Moving and re-organizing data
Chapter 18: The AWR and the Alert system
Chapter 19: Performance tuning
Chapter 20: The Resource Manager
Chapter 21: The Scheduler
Part IV: DBA2
Chapter 22: Configuring the DB for backup and recovery
Chapter 23: Backup with RMAN
Chapter 24: Restore and Recover with RMAN
Chapter 25: Diagnosing Failures
Chapter 26: Flashback
Chapter 27: Duplicating a Database
Chapter 28: Encrypting, Securing, Monitoring, and Tuning RMAN Backups
Part V: Upgrades and Multitenant
Chapter 29: Upgrading Oracle Database Software
Chapter 30: Upgrading an Oracle database
Chapter 31: Multitenant Container and Pluggable Database Architecture
Chapter 32: Creating and Managing Multitenant Container and Pluggable Databases
Chapter 33: Managing Storage, Security, Availability and Performance in a CDB and PDBs
show more

Rating details

4 ratings
2.75 out of 5 stars
5 0% (0)
4 25% (1)
3 25% (1)
2 50% (2)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X