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

ExamREVIEW

Softcover

ISBN 10: 1982018747 ISBN 13: 9781982018740

Publisher: CreateSpace Independent Publishing Platform, 2017

Synopsis

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.

About this title

About the Author

ExamREVIEW.NET (a.k.a. ExamREVIEW) is an independent content developer not associated/affiliated with the certification vendor(s) mentioned throughout this book. The name(s), title(s) and award(s) of the certification exam(s) mentioned in this book are the trademark(s) of the respective certification vendor(s). We mention these name(s) and/or the relevant terminologies only for describing the relevant exam process(es) and knowledge.

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2017
• ISBN 10: 1982018747
• ISBN 13: 9781982018740
• Binding: Paperback
• Language: English
• Number of pages: 122