Biju Thomas 
OCA [PDF ebook] 
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.

Содержание

Introduction xx

Assessment Test xxxv

Part I Oracle Database 12c: SQL Fundamentals 1

Chapter 1 Introducing Oracle Database 12c RDBMS 3

Chapter 2 Introducing SQL 35

Chapter 3 Using Single-Row Functions 89

Chapter 4 Using Group Functions 175

Chapter 5 Using Joins and Subqueries 227

Chapter 6 Manipulating Data 281

Chapter 7 Creating Tables and Constraints 319

Part II Oracle Database 12c: Installation and Administration 381

Chapter 8 Introducing Oracle Database 12c Components and Architecture 383

Chapter 9 Creating and Operating Oracle Database 12c 431

Chapter 10 Understanding Storage and Space Management 511

Chapter 11 Managing Data Concurrency and Undo 569

Chapter 12 Understanding Oracle Network Architecture 603

Chapter 13 Implementing Security and Auditing 677

Chapter 14 Maintaining the Database and Managing Performance 753

Chapter 15 Using Backup and Recovery 825

Chapter 16 Controlling Resources and Jobs 903

Chapter 17 Upgrading to Oracle Database 12c 957

Chapter 18 Using Grid Infrastructure and Data Movement Tools 1005

Appendix A Answers to Review Questions 1083

Appendix B About the Additional Study Tools 1119

Index 1123

Об авторе

Biju Thomas OCA, OCP, is a Senior Oracle Solutions
Architect with more than 20 years of Oracle development and
database management experience. He has strong skills in database
design and administration, performance tuning, and solution
architecture. He has coauthored six Oracle Sybex certification
books.