OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062

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

It’s been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams.

• Provides you with a solid understanding of restricting and sorting data
• Walks you through using conversion functions and conditional expressions
• Addresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery
• Explores the Oracle database architecture and discusses preparing 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 the dramatically updated Oracle 12c OCA exams.

Table of Contents

Part I: Oracle Database 12c: SQL Fundamentals
Chapter 1: Introducing Oracle Database 12c RDBMS
Chapter 2: Introducing SQL
Chapter 3: Using Single-Row Functions
Chapter 4: Using Group Functions
Chapter 5: Using Joins and Subqueries
Chapter 6: Manipulating Data
Chapter 7: Creating Tables and Constraints

Part II: Oracle Database 12c: Installation and Administration
Chapter 8: Introducing Oracle Database 12c Components and Architecture
Chapter 9: Creating and Operating Oracle Database 12c
Chapter 10: Understanding Storage and Space Management
Chapter 11: Managing Data Concurrency
Chapter 12: Understanding Oracle Network Architecture
Chapter 13: Implementing Security and Auditing
Chapter 14: Maintaining the Database and Managing Performance
Chapter 15: Using Backup and Recovery
Chapter 16: Controlling Resources and Jobs
Chapter 17: Upgrading to Oracle Database 12c
Chapter 18: Using Grid Infrastructure and Data Movement Tools

Appendix A: Answers to Review Questions
Appendix B: About the Additional Study Tools