Practice Exam 1Z0-062: Oracle Database 12c: Installation and Administration

$109.00
$131.89 incl. vat

duration: 3 hours |

access duration: 180 days |

Details

Proefexamen 1Z0-062: Oracle Database 12c: Installation and Administration

(English version)

Result

Please note that this exam retires on Jan. 30, 2023.

Prerequisites

You have successfully finished a training course for this exam. A training course for this exam is available through us.

Target audience

Database Administrators

Content

Practice Exam 1Z0-062: Oracle Database 12c: Installation and Administration

3 hours

Exploring the Oracle Database Architecture

  • List the architectural components of Oracle Database
  • Explain the memory structures
  • Describe the background processes
  • Explain the relationship between logical and physical storage structures

Implementing Oracle Database Auditing

  • Explain DBA responsibilities for security and auditing
  • Enable standard database auditing and unified auditing

Backup and Recovery Concepts

  • Identify the importance of checkpoints, redo log files, and archive log files

Backup and Recovery: Configuration

  • Configure the fast recovery area
  • Configure ARCHIVELOG mode

Performing Database Backups

  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • Automate database backups
  • Manage backups

Performing Database Recovery

  • Determine the need for performing recovery
  • Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of Control file, Redo log file and Data file

Moving Data

  • Use SQL*Loader to load data from a non-Oracle database
  • Use external tables to move data via platform-independent files
  • Explain the general architecture of Oracle Data Pump
  • Use Data Pump Export and Import to move data between Oracle databases

Performing Database Maintenance

  • Manage the Automatic Workload Repository (AWR
  • Use the Automatic Database Diagnostic Monitor (ADDM
  • Set alert thresholds
  • User server-generated alerts

Managing Performance

  • Use Automatic Memory Management
  • Use the Memory Advisor to size memory buffers

Managing Performance: SQL Tuning

  • Manage optimizer statistics
  • Use the SQL Access Advisor to tune a workload

Managing Resources Using Database Resource Manager

  • Configure the Database Resource Manager

Oracle Database Management Tools

  • Use database management tools

Automating Tasks by Using Oracle Scheduler

  • Use Oracle Scheduler to simplify management tasks
  • Use job chains to perform a series of related tasks

Oracle Software Installation Basics

  • Plan for an Oracle Database software installation

Installing Oracle Grid Infrastructure for a Standalone Server

  • Configure storage for Oracle Automatic Storage Management (ASM

Installing Oracle Database Software

  • Install the Oracle Database software

Creating an Oracle Database Using DBCA

  • Create a database by using the Database Configuration Assistant (DBCA
  • Configure database options by using DBCA

Upgrading Oracle Database Software

  • Describe upgrade methods

Performing Post-Upgrade Tasks

  • Migrate to unified auditing

Oracle Database Instance

  • Understand initialization parameter files
  • Start up and shut down an Oracle database instance
  • View the alert log and access dynamic performance views

Migrating Data by Using Oracle Data Pump

  • Migrate data by using Oracle Data Pump

Configuring the Oracle Network Environment

  • Configure Oracle Net Services
  • Use tools for configuring and managing the Oracle network
  • Configure client-side network

Managing Database Storage Structures

  • Describe the storage of table row data in blocks
  • Create and manage tablespaces

Administering User Security

  • Create and manage database user accounts:
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles

Managing Space

  • Explain how Oracle database server automatically manages space
  • Proactively monitor and manage tablespace space usage
  • Use the Segment Advisor

Managing Undo Data

  • Explain DML and undo data generation
  • Monitor and administer undo data
  • Describe the difference between undo data and redo data
  • Configure undo retention

Managing Data Concurrency

  • Describe the locking mechanism and how Oracle manages data concurrency
  • Monitor and resolve locking conflicts

Course options

We offer several optional training products to enhance your learning experience. If you are planning to use our training course in preperation for an official exam then whe highly recommend using these optional training products to ensure an optimal learning experience. Sometimes there is only a practice exam or/and practice lab available.

Optional practice exam (trial exam)

To supplement this training course you may add a special practice exam. This practice exam comprises a number of trial exams which are very similar to the real exam, both in terms of form and content. This is the ultimate way to test whether you are ready for the exam. 

Optional practice lab

To supplement this training course you may add a special practice lab. You perform the tasks on real hardware and/or software applicable to your Lab. The labs are fully hosted in our cloud. The only thing you need to use our practice labs is a web browser. In the LiveLab environment you will find exercises which you can start immediatelyThe lab enviromentconsist of complete networks containing for example, clients, servers,etc. This is the ultimate way to gain extensive hands-on experience. 

WHY_ICTTRAININGEN

Via ons opleidingsconcept bespaar je tot 80% op trainingen

Start met leren wanneer je wilt. Je bepaalt zelf het gewenste tempo

Spar met medecursisten en profileer je als autoriteit in je vakgebied.

Ontvang na succesvolle afronding van je cursus het officiële certificaat van deelname van Icttrainingen.nl

Krijg inzicht in uitgebreide voortgangsinformatie van jezelf of je medewerkers

Kennis opdoen met interactieve e-learning en uitgebreide praktijkopdrachten door gecertificeerde docenten

Orderproces

Once we have processed your order and payment, we will give you access to your courses. If you still have any questions about our ordering process, please refer to the button below.

read more about the order process

What is included?

Certificate of participation No
Monitor Progress Yes
Examination possibleYes
Mobile ready No
Sharing knowledge Unlimited access to our IT professionals community
Study advice Our consultants are here for you to advice about your study career and options
Study materials Certified teachers with in depth knowledge about the subject.
Service World's best service

Platform

Na bestelling van je training krijg je toegang tot ons innovatieve leerplatform. Hier vind je al je gekochte (of gevolgde) trainingen, kan je eventueel cursisten aanmaken en krijg je toegang tot uitgebreide voortgangsinformatie.

Life Long Learning

Follow multiple courses? Read more about our Life Long Learning concept

read more

Contact us

Need training advise? Contact us!


contact