Oracle Database Admin I Exam 1Z0-061 (SQL) & 1Z0-062 (12c) ExamFOCUS Study Notes & Review Questions 2013 - Softcover

The latest Oracle database admin I exam covers Oracle Database Release 12c. The exam has two major sections, which are administration and installation. These are the topics covered: << Oracle Database Administration >> Exploring the Oracle Database Architecture Oracle Database Management Tools Oracle Database Instance Configuring the Oracle Network Environment Managing Database Storage Structures Administering User Security Managing Space Managing Undo Data Managing Data Concurrency Implementing Oracle Database Auditing Backup and Recovery Concepts Backup and Recovery Configuration Performing Database Backups Performing Database Recovery Moving Data Performing Database Maintenance Managing Performance Managing Performance: SQL Tuning Managing Resources Using Database Resource Manager Automating Tasks by Using Oracle Scheduler << Installing, Upgrading and Patching the Oracle Database >> Oracle Software Installation Basics Installing Oracle Grid Infrastructure for a Standalone Server Installing Oracle Database Software Creating an Oracle Database Using DBCA Using Oracle Restart Upgrading Oracle Database Software Preparing to Upgrade to Oracle Database 12c Upgrading to Oracle Database 12c Performing Post-Upgrade Tasks Migrating Data by Using Oracle Data Pump The SQL Fundamental exam 1z0-061 covers: Introduction Retrieving Data using the SQL SELECT Statement Restricting and Sorting Data Using Single-Row Functions to Customize Output Using Conversion Functions and Conditional Expressions Reporting Aggregated Data Using the Group Functions Displaying Data From Multiple Tables Using Joins Using Subqueries to Solve Queries Using the SET Operators Managing Tables using DML statements Introduction to Data Definition Language We give you knowledge information relevant to the exam specifications. To be able to succeed in the real exams, you’ll need to apply your earned knowledge to the question scenarios. This ExamFOCUS book focuses on the more difficult topics that will likely make a difference in exam results. Throughout this book we run Oracle 12c (64 bit only) on Windows Server 2012 for demonstration. The evaluation version of 12c can be downloaded free of charge if you join OTN (it is also free). Your server needs to have sufficient RAM and drive space to accommodate Oracle.

In the early days of certification study preparation the focus was almost exclusively on cramming. We had a new medium for content that didn’t come with the same restrictions as the more traditional forms. We could present material as we felt was necessary and we could do it quicker. As the certification industry grew, so did the approach to gaining readership. In many cases, publishers had their focus shifted away from ultimate understanding of what was being covered, to producing word-for-word exact-match contents significantly motivated by increasing revenue. While it’s definitely easier to produce content by going that route, we don’t believe it’s the only way to conquer an exam. At the same time, we don’t believe readers need the 500-page megatext. As long as there’s a balance, we are happy. Our mission at ExamREVIEW is to be a part of that balance. Our No-Frills ExamFOCUS study notes are written to be plain simple and straight forward. We don’t paginate material to increase page count, we break them apart across logical boundaries to improve readability. All fancy extra features are removed. We provide study notes that are concise and occupying less pages (so to save trees). And we want you to be up and ready as easy as possible! We are the original developer of our NO FRILLS Exam prep products. Contents are developed entirely in-house, basing on our own research efforts. We believe that with the right preparation material and the right study approach, everyone can clear exams ethically.