Softcover

ISBN 10: 111864395X ISBN 13: 9781118643952

Publisher: Sybex, 2014

An all-in-one study guide prepares you for the updated OracleCertified Associate certification

It's been nearly six years since Oracle updated its cornerstonedatabase software, making the demand for a comprehensive studyguide for the OCA 12c certification a top priority. This resourceanswers that demand. Packed with invaluable insight, chapter reviewquestions, bonus practice exams, hundreds of electronic flashcards,and a searchable glossary of terms, this study guide prepares youfor the challenging Oracle certification exams.

• Provides you with a solid understanding of restricting andsorting data
• Walks you through using conversion functions and conditionalexpressions
• Addresses displaying data from multiple tables, manipulatingdata, database maintenance, and database backups and recovery
• Explores the Oracle database architecture and discussespreparing the database environment, creating an Oracle database,and managing the Oracle instance
• Focuses on administering and implementing user security

This must-have study guide thoroughly prepares you to take thedramatically updated Oracle 12c OCA exams.

From the Back Cover:

Includes Real-World Scenarios, Hands-On Exercises, and Access toExam 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 OCAexams

Covering both the 1Z0-061 and 1Z0-062 exams, this comprehensiveguide helps you prepare for these challenging exams with anextensive set of study tools, including an assessment test, chapterreview questions, practice exam questions, electronic flashcards,and a glossary of key terms. Written by an industry expert withhands-on Oracle database experience, this book not only preparesyou for the OCA exams, but also for the day-to-day work world of adatabase administrator. As with all Sybex Study Guides, insideyou’ll find:

Full coverage of all exam objectives in a systematic approach,so you can be confident you’re getting the instruction youneed for the exam

Practical labs to reinforce critical skills

Real-World scenarios that put what you’ve learned in thecontext of actual job roles

Challenging review questions in each chapter to prepare you forexam day

Exam Essentials, a key feature in each chapter that identifiescritical areas you must become proficient in before taking theexam

A handy section that maps every official exam objective to thecorresponding chapter in the book so you can track your exam prepobjective by objective

Sybex Exam Prep Tools

Go to www.sybex.com/go/oca12sg for access to a full set of studytools 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 keytopics:

• 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

About the Author:

Biju Thomas OCA, OCP, is a Senior Oracle SolutionsArchitect with more than 20 years of Oracle development anddatabase management experience. He has strong skills in databasedesign and administration, performance tuning, and solutionarchitecture. He has coauthored six Oracle Sybex certificationbooks.