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

The 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.