Includes Real-World Scenarios, Hands-On Exercises, and Access to Exam Prep Software Featuring:

• Custom Testing Environment
• Hundreds of Practice Questions
• Over 500 Electronic Flashcards
• Glossary of Key Terms

Two-in-one test prep for the updated Oracle 12c OCA exams

Covering both the 1Z0-061 and 1Z0-062 exams, this comprehensive guide helps you prepare for these challenging exams with an extensive set of study tools, including an assessment test, chapter review questions, practice exam questions, electronic flashcards, and a glossary of key terms. Written by an industry expert with hands-on Oracle database experience, this book not only prepares you for the OCA exams, but also for the day-to-day work world of a database administrator. As with all Sybex Study Guides, 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 labs 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 section that maps every official exam objective to the corresponding chapter in the book so you can track your exam prep objective by objective

Sybex Exam Prep Tools

Go to [...] for access to a full set of study tools to help you prepare for the exam, including:

• Chapter review questions
• Full-length practice exams
• Over 500 electronic flashcards
• Glossary of key terms
• Bonus author content

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