• Open Daily: 10am - 10pm
    Alley-side Pickup: 10am - 7pm

    3038 Hennepin Ave Minneapolis, MN
    612-822-4611

Open Daily: 10am - 10pm | Alley-side Pickup: 10am - 7pm
3038 Hennepin Ave Minneapolis, MN
612-822-4611
Oracle Database Admin I Exam 1Z0-061 (SQL) & 1Z0-062 (12c) ExamFOCUS Study Notes & Review Questions 2018 Edition

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

Paperback

Test Prep

ISBN10: 1982018747
ISBN13: 9781982018740
Publisher: Createspace
Published: Dec 25 2017
Pages: 122
Weight: 0.57
Height: 0.26 Width: 7.99 Depth: 10.00
Language: English
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.

2 different editions

Also available

Also in

Test Prep