Register Login

Home >Oracle >OCA DBA 10g >Books

Oracle Home  |  Practice Questions  |  Resources  |  Books  |  CertNotes

OCA exam simulator consists of 200+ questions with detailed answers. The practice tests conform to the latest objectives. The question types include Multiple Choice , True/False, Drag-n-drop, Fill-in-the-blank questions.

Download OCA Practice Tests

Books Recommended For OCA™

  Oracle books

Title : OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Osborne ORACLE Press Series)

Author : John Watson , Roopesh Ramklass , Bob Bryla

Publisher : McGraw-Hill Osborne Media; 1 edition (August 17, 2009)

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:

  1. Three full practice exams
  2. Detailed answers and explanations
  3. Score report performance assessment tool
  4. Complete electronic book
  5. Three bonus exams available with free online registration
  • Hardcover: 1050 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (August 17, 2009)
  • Language: English
  • ISBN-10: 0071629181

  Oracle books

Title : Oracle Applications DBA Covers 11i and R12

Author : Joyjeet Banerjee

Publisher : McGraw-Hill Education (India); 1st edition (August 11, 2008)

Oracle Applications DBA covers all the pertinent aspects of administrating Oracle Applications—from installation to day-to-day maintenance. It covers upgrading, cloning, patching, maintenance and troubleshooting of the application system. Embellished with over 350 screenshots and illustrations, it helps in administrating complex Oracle Database in an easy-to-navigate format. To help readers manage Oracle Applications without much difficulty, a comprehensive discussion on upgrading Oracle Applications in Unix environment has been provided. Further the book includes a balanced coverage of Oracle 11i and R12 – making it a must-have for experienced Oracle Applications DBAs. Professionals who are keen to migrate from DBA to Apps DBA profile would also find the book useful.

  • Paperback: 418 pages
  • Publisher: McGraw-Hill Education (India); 1st edition (August 11, 2008)
  • Language: English
  • ISBN-10: 0070077290

 

 

Title: OCA: Oracle Database 12c Administrator Certified Associate Study Guide

Author: Biju Thomas

Publisher: Sybex; 1 edition (May 12, 2014)

Includes coverage of all exam objectives, including these key topics:
  • Restricting and Sorting Data
  • Using Conversion Functions and Conditional Expressions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Exploring the Oracle Database Architecture
  • Managing the Database Instance
  • Creating an Oracle Database using DBCA
  • Managing the Oracle Instance
  • Managing Database Storage Structures
  • Administering User Security
  • Performing Database Maintenance
  • Performance Management
  • Moving Data
  • Working with Oracle Support

 

  • Paperback: 1224 pages
  • Language: English
  • ISBN-10: 111864395X

 

Title: OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061)

Author: Roopesh Ramklass

Publisher: McGraw-Hill Education; 2 edition (April 18, 2014)

Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including:
  • Data retrieval using the SQL SELECT statement
  • Restricting and sorting data
  • Single-row functions
  • Using conversion functions and conditional expressions
  • Reporting aggregated data with the group functions
  • Displaying data from multiple tables with joins
  • Using subqueries to solve problems
  • Using the set operators
  • Manipulating data with DML statements
  • Using DDL statements to create and manage tables
  • Series: Oracle Press
  • CD-ROM: 592 pages
  • Language: English
  • ISBN-10: 0071820280

 

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

Author: John Watson, Roopesh Ramklass, Bob Bryla

Publisher: McGraw-Hill Education; 2 edition (August 24, 2015)

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
  • Series: All-in-One
  • CD-ROM: 1072 pages
  • Language: English
  • ISBN-10: 0071828087

  Oracle books

Title :OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Osborne ORACLE Press Series)

Author : Bob Bryla

Publisher : McGraw-Hill Osborne Media; 2 edition (December 19, 2008)

A Fully Integrated Study System for OCP Exam 1Z0-053

Prepare for the Oracle Certified Professional Oracle Database 11g: Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary 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 OCP objectives for exam 1Z0-053, including:

  • Database structure and Oracle Automatic Storage Management
  • Configuring database recoverability
  • Oracle Recovery Manager (RMAN)
  • Oracle Flashback
  • Memory management techniques
  • Database tuning advisors
  • Disk space and resource management
  • Configuring database diagnostics
  • Administering the Oracle Scheduler
  • Database globalization

On the CD-ROM:

- One full practice exam that simulates the actual OCP exam

- Detailed answers and explanations

- Score report performance assessment tool

- Complete electronic book

- Bonus exam available free with online registration

  • Paperback: 752 pages
  • Publisher: McGraw-Hill Osborne Media; 2 edition (December 19, 2008)
  • Language: English
  • ISBN-10: 0071597093

  Oracle books

Title :OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

Author : John Watson

Publisher : McGraw-Hill Osborne Media; 1 edition (May 2, 2008)

A Fully Integrated Study System for OCA Exam 1Z0-052

Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary 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 OCA objectives for exam 1Z0-052, including:

  • Database architecture
  • Creating an Oracle Database
  • Managing the Oracle instance
  • Configuring and managing the Oracle network
  • Managing database storage structures
  • Administering user security
  • Managing schema objects, data and concurrency, and undo data
  • Implementing Oracle Database security
  • Database maintenance and performance management
  • Backup and recovery
  • Moving data
  • Intelligent infrastructure enhancements

On the CD-ROM:

- One full practice exam that simulates the actual OCA exam

- Detailed answers and explanations

- Score report performance assessment tool

- Complete electronic book

- Bonus exam available free with online registration

  • Paperback: 733 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (May 2, 2008)
  • Language: English
  • ISBN-10: 0071591028

 

Title :OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Osborne ORACLE Press Series)

Author : John Watson

Publisher : McGraw-Hill Osborne Media; 1 edition (May 29, 2008)

A Fully Integrated Study System for OCA Exam 1Z0-051

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary 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 OCA objectives for exam 1Z0-051, including:

  • SQL SELECT statements
  • Restricting and sorting data
  • Single-row functions
  • Conversion functions and conditional expressions
  • Group functions
  • Displaying data from multiple tables
  • Subqueries
  • Set operators
  • DML and DDL statements
  • Schema objects

On the CD-ROM:

- One full practice exam that simulates the actual OCA exam
- Detailed answers and explanations
- Score report performance assessment tool
- Complete electronic book
- Bonus exam available free with online registration

  • Paperback: 581 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (May 29, 2008)
  • Language: English
  • ISBN-10: 0071597867

  Oracle books

Title :OCP: Oracle Database 11g Administrator Certified Professional Certification Kit: (1Z0-051, 1Z0-052, and 1Z0-053)

Author : Biju Thomas

Publisher : Sybex; Pap/Cdr edition (April 13, 2009)

Prepare for your OCP in Oracle Database 11g with this all-in-one study kit

Study, practice, and review for certification as an Oracle Database 11g Administrator Certified Professional with this complete study kit that prepares you for three required exams: 1Z0-051, 1Z0-052, and 1Z0-053.

OCA: Oracle Database 11g Administrator Certified Associate Study Guide

This book covers two required OCA certification exams

  • Full coverage of all exam objectives for two of the required OCA exams: Oracle Database 11g: SQL Fundamentals I (Exam 1Z0-051) and Oracle Database 11g: Administration I (Exam 1Z0-052)
  • Covers essential topics such as SQL SELECT statements, group functions, creating schema objects, and much more
  • Reinforces learning through practical, hands-on exercises
  • Real-world scenarios put what you've learned in the context of actual job roles
  • Challenging review questions in each chapter prepare you for exam day
  • Exam Essentials, a key feature in each chapter, identifies critical areas you must become proficient in before taking the exam
  • An interactive CD includes the Sybex test engine, electronic flashcards, practice exams, and a searchable PDF of the book

OCP: Oracle Database 11g Administrator Certified Professional Study Guide

Here's the prep guide for OCP exam 1Z0-053

- Full coverage of all exam objectives for Oracle Database 11g: Administration II (Exam 1Z0-053) in a systematic approach, so you can be confident you're getting the instruction you need for the exam

- Practical hands-on exercises reinforce critical skills

- Real-world scenarios put what you've learned in the context of actual job roles

- Challenging review questions in each chapter prepare you for exam day

- Extra exam practice is available with a bonus exercise workbook in the Appendix

- Exam Essentials, a key feature in each chapter, identifies critical areas you must become proficient in before taking the exam

- An interactive CD includes the Sybex test engine, electronic flashcards, practice exams, and a searchable PDF of the book

  • Paperback: 2040 pages
  • Publisher: Sybex; Pap/Cdr edition (April 13, 2009)
  • Language: English
  • ISBN-10: 0470395141

  Oracle books

Title :Oracle Database 11g DBA Handbook (Osborne ORACLE Press Series)

Author : Bob Bryla

Publisher : McGraw-Hill Osborne Media; 1 edition (December 6, 2007)

The Essential Resource for Oracle DBAs--Fully Updated and Expanded

Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net.

- Plan and deploy permanent, temporary, and bigfile tablespaces

- Optimize disk allocation, CPU usage, I/O throughput, and SQL queries

- Develop powerful database management applications

- Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management

- Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets

- Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control

- Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard

- Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor

- Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import

- Work with networked databases, data warehouses, and VLDBs

- Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more

  • Paperback: 670 pages
  • Publisher: Sybex; Pap/Cdr St edition (April 6, 2009)
  • Language: English
  • ISBN-10: 0071496637

  Oracle books

Title :OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0-051 and 1Z0-052)

Author : Biju Thomas

Publisher : McGraw-Hill Osborne Media; 1 edition (December 6, 2007)

Prepare for two OCA certification exams with this one book

Study, practice, and review for OCA certification in Oracle 11g, Oracle's new release of its top-selling database software. Inside this in-depth guide, you'll find full coverage of essential topics for two required OCA certification exams: SQL Fundamentals I (1Z0-051) and Administration I (1Z0-052). Explore topics such as basic SQL SELECT statements, group functions, creating schema objects, restricting and sorting data, and much more with this essential two-in-one guide. Inside, you'll find:

  • Full coverage of all exam objectives in a systematic approach, so you can be confident you're getting the instruction you need for the exam
  • Practical hands-on exercises to reinforce critical skills
  • Real-world scenarios that put what you've learned in the context of actual job roles
  • Challenging review questions in each chapter to prepare you for exam day
  • Exam Essentials, a key feature in each chapter that identifies critical areas you must become proficient in before taking the exam
  • A handy tear card that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objective
  • Paperback: 1152 pages
  • Publisher: Sybex; Pap/Cdr St edition (April 6, 2009)
  • Language: English
  • ISBN-10: 0470395125

 

Oracle Database 11g PL/SQL Programming (Osborne ORACLE Press Series)

Author : D.CS. Michael McLaughlin

Publisher : McGraw-Hill Osborne Media; 1 edition (March 21, 2008)

  • Create, debug, and manage Oracle-driven PL/SQL programs
  • Use PL/SQL structures, delimiters, operators, variables, and statements
  • Identify and eliminate errors using PLSQL_WARNINGS and exception handlers
  • Work with functions, procedures, packages, collections, and triggers
  • Define and deploy varray, nested table, and associative array data types
  • Handle external routines, object types, large objects, and secure files
  • Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
  • Call external procedures through Oracle Net Services and PL/SQL wrappers
  • Integrate internal and server-side Java class libraries using Oracle JVM
  • Develop robust Web applications using PL/SQL Gateway and Web Toolkit
 
  • Paperback: 835 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (March 21, 2008)
  • Language: English
  • ISBN-10: 0071494456

 

 

OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047 (Osborne Oracle Press Series)

Author : Steve O'Hearn

Publisher : McGraw-Hill Osborne Media; 1 edition (November 22, 2009)

 

This exclusive Oracle Press guide covers all of the objectives on the newly created Oracle SQL Expert exam in detail, including control privileges, creating indexes and constraints, altering existing schema objects, creating and querying external tables, and using the advanced SQL features to query and manipulate data within the database.

Oracle Database SQL Expert Exam Guide features real-world examples, practice questions, and chapter summaries to help you learn the material. The CD-ROM contains two practice exams and an electronic copy of the book.

  • Paperback: 712 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (November 22, 2009)
  • Language: English
  • ISBN-10: 0071614214

 

Disclaimer: CertExams.com is neither associated nor affiliated with Oracle® or any other company. OCA™ is trademarks of Oracle® and duly acknowledged. The practice tests material is a copyright of CertExams.com and the same is not approved or endorsed by respective certifying bodies.

Real Time Web Analytics

Clicky