A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053 Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exams 1Z0-051, 1Z0-052, and 1Z0-053, including: Instance management Networking and storage Security SQL Oracle Recovery Manager and Oracle Flashback Oracle Automatic Storage Management Resource manager Oracle Scheduler Automatic workload repository Performance tuning Three bonus exams available with free online registration

A Fully Integrated Study System for OCA Exams 1Z0-051 and 1Z0-052, and OCP Exam 1Z0-053 Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exams 1Z0-051, 1Z0-052, and 1Z0-053, including: Instance management Networking and storage Security SQL Oracle Recovery Manager and Oracle Flashback Oracle Automatic Storage Management Resource manager Oracle Scheduler Automatic workload repository Performance tuning And more On the CD-ROM: Three full practice exams Detailed answers and explanations Score report performance assessment tool Complete electronic book Three bonus exams available with free online registration

A Fully Integrated Study System for OCA Exam 1Z0-051 Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-051, including: SQL SELECT statements Restricting and sorting data Single-row functions Conversion functions and conditional expressions Group functions Displaying data from multiple tables Subqueries Set operators DML and DDL statements Schema objects On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration

This Oracle Press certification exam guide prepares you for the new Oracle Database 12c certification track, including the core requirements for OCA and OCP certification. OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) covers all of the exam objectives on the Installation and Administration, SQL Fundamentals, and Advanced Administration exams in detail. Each chapter includes examples, practice questions, Inside the Exam sections highlighting key exam topics, a chapter summary, and a two-minute drill to reinforce essential knowledge. 300+ practice exam questions match the format, topics, and difficulty of the real exam. Electronic content includes interactive practice exam software with hundreds of questions that include detailed answers and explanations, and a score report performance assessment tool Ideal as both exam guide and on-the-job reference The most comprehensive single preparation tool for the Oracle Database 12c OCA and OCP certification exams

A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration

Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you’ll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. For Instructors: Teaching supplements are available for this title.

A Complete Study System for OCA Exam 1Z0-061 Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including: Data retrieval using the SQL SELECT statement Restricting and sorting data Single-row functions Using conversion functions and conditional expressions Reporting aggregated data with the group functions Displaying data from multiple tables with joins Using subqueries to solve problems Using the set operators Manipulating data with DML statements Using DDL statements to create and manage tables Electronic content includes: 150+ practice exam questions with detailed answers and explanations Score report performance assessment tool

A Complete Study System for OCP Exam 1Z0-063 Prepare for the Oracle Certified Professional Oracle Database 12c Advanced Administration exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-063, including: Configuring and managing Oracle Recovery Manager (RMAN) settings Using the Oracle RMAN recovery catalog Performing backup and recovery Diagnosing database failures and using the automatic diagnostic repository Encrypting, securing, monitoring, and tuning Oracle RMAN backups Configuring and using flashback features Transporting and copying tablespaces and databases Creating and managing multitenant container databases and pluggable databases Using the Oracle Data Pump, SQL*Loader, and auditing features Electronic content includes: 150+ practice exam questions Test engine that provides practice exams or quizzes that can be customized by chapter or exam objective PDF copy of the book

The Most Authoritative OCA/OCP Exam Guide Available Prepare to pass the OCA and OCP Oracle Database 10g certification exams with help from this Oracle Press guide. With complete coverage of all the material on Exam #1Z0-042 Oracle Database 10g: Administration I and Exam #1Z0-043 Oracle Database 10g: Administration II, this book covers everything you need to know to pass both exams. Inside, you’ll find helpful exam tips, hundreds of practice questions, and real-world exercises. This comprehensive guide serves as both a study tool and an on-the-job reference. Get full details on all exam objectives, including how to: Install Oracle Database 10g and create a database Use SQL, SQL*Plus, iSQL*Plus, and PL/SQL Create and manage database user accounts Configure Oracle Networking Manage shared servers Monitor, tune, and troubleshoot a database Handle database backup, restore, and recovery Use Oracle Recovery Manager and Oracle Flashback Configure and manage security Use Automatic Storage Management and Resource Manager Automate administrative tasks Included on the CD-ROM Electronic Practice Test engine with two full practice exams Complete electronic book