OCA 1Z0-062

Exploring the Oracle Database Architecture
  • List the architectural components of Oracle Database – POST I
  • Explain the memory structures – POST I
  • Describe the background processes – POST I

Oracle Database Instance

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

Administering User Security

  • Create and manage database user accounts – POST I
  • Grant and revoke privileges – POST I
  • Create and manage roles – POST I
  • Create and manage profiles – POST I

Create and manage tablespaces

Managing Data Concurrency

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

Backup and Recovery Concepts

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

Performing Database Backups

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

Moving Data

  • Describe ways to move 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

Managing Performance: SQL Tuning

  • Use the SQL Tuning advisor

Creating an Oracle Database Using DBCA 

  • Generate database creation scripts by using DBCA – POST I
  • Manage database design templates by using DBCA – POST I

Introduction to DBAAS

  • Recognize the difference between a DBaaS Instance and a Database Instance
  • Navigate with My Services Dashboard
  • User authentication and roles
  • Generate a Secure Shell (SSH) Public/Private Key Pair

Oracle Database Management Tools

  • Use database management tools

Configuring the Oracle Network Environment

  • Configure Oracle Net Services – POST I
  • Use tools for configuring and managing the Oracle network – POST I
  • Configure client-side network – POST I
  • Configure communication between databases – POST I

Managing Database Storage Structures

  • Describe the storage of table row data in blocks – POST I
  • Create and manage tablespaces – POST IPOST II

Managing Undo Data

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

Implementing Oracle Database Auditing

  • Enable standard database auditing and unified auditing – POST I

Backup and Recovery Configuration

  • Configure the fast recovery area
  • Configure ARCHIVELOG mode

Performing Database Recovery

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

Performing Database Maintenance

  • Use server-generated alerts

Automating Tasks by Using Oracle Scheduler

  • Use Oracle Scheduler to simplify management tasks
  • Use job chains to perform a series of related tasks
  • Use Scheduler jobs on remote systems
  • Use advanced Scheduler features to prioritize jobs

Upgrading Oracle Database Software  

  • Describe data migration methods
  • Describe the upgrade process
Anúncios
Esse Blog é reconhecido pela
Certificações
Sou articulista

Clique para seguir este blog e receber notificações via email de novos posts.

Tércio Costa

Tércio Costa

Meu nome é Tércio Costa, sou formado em Ciências da Computação pela UFPB, tenho a certificação Oracle SQL Expert e OCP PL/SQL, mantendo um blog reconhecido pela OTN(oraclepress.wordpress.com), no qual também publico artigos técnicos no portal OTN, no portal http://www.profissionaloracle.com.br/gpo e na revista SQL Magazine. Além de tudo isto sou um Oracle ACE Associate por estar sempre contribuindo para a comunidade com um bom nível de expertise.

Links Pessoais

Serviços verificados

Visualizar Perfil Completo →

Total de Visualizações da Página
  • 138.087 Visualizações
%d blogueiros gostam disto: