An all-in-one study guide prepares you for the updated OracleCertified Associate certificationIt'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 securityThis must-have study guide thoroughly prepares you to take thedramatically updated Oracle 12c OCA exams.

Introduction xxAssessment Test xxxvPart I Oracle Database 12c: SQL Fundamentals 1Chapter 1 Introducing Oracle Database 12c RDBMS 3Chapter 2 Introducing SQL 35Chapter 3 Using Single-Row Functions 89Chapter 4 Using Group Functions 175Chapter 5 Using Joins and Subqueries 227Chapter 6 Manipulating Data 281Chapter 7 Creating Tables and Constraints 319Part II Oracle Database 12c: Installation and Administration 381Chapter 8 Introducing Oracle Database 12c Components and Architecture 383Chapter 9 Creating and Operating Oracle Database 12c 431Chapter 10 Understanding Storage and Space Management 511Chapter 11 Managing Data Concurrency and Undo 569Chapter 12 Understanding Oracle Network Architecture 603Chapter 13 Implementing Security and Auditing 677Chapter 14 Maintaining the Database and Managing Performance 753Chapter 15 Using Backup and Recovery 825Chapter 16 Controlling Resources and Jobs 903Chapter 17 Upgrading to Oracle Database 12c 957Chapter 18 Using Grid Infrastructure and Data Movement Tools 1005Appendix A Answers to Review Questions 1083Appendix B About the Additional Study Tools 1119Index 1123