Certificação Oracle

[M4cJun1or 0]

Olá comunidade Oracle!Pessoal,É o seguinte... estou querendo saber... Qual é o tempo médio de estudo para estar preparado para o primeiro teste de certificação Oracle (OCP)?Obrigado!!!

[alphamek 2]

Olá rapaz.... Seguinte, para o primeiro teste, que é Fundamentos em SQL, dependendo do seu conhecimento em SQL e experiência, uns 2 meses. O curso completo, dependendo das datas que tu especificar no treinamento, pode levar até 6 meses por completo. Para OCP são 4 provas. 1º - Fundamentos em SQL 2º - Fundamentos I 3º - Fundamentos II 4º - Backup & Recovery PARABENS! Virou OCP! heheheheheheheheh Abraços,

[rick_simmons 0]

1º - Fundamentos em SQL

2º - Fundamentos I

3º - Fundamentos II

4º - Backup & Recovery

<{POST_SNAPBACK}>

Caro alphamek, poderia dar exemplos sobre os conteúdos das provas de Fundamentos I e Fundamentos II? Obrigado.

[alphamek 2]

Olhem o contéudo de todas as provas, OK! Isso para versão 8i.

 

Introduction

Describing the Lifecycle Development Phases

Defining a Database

Discussing the Theoretical, Conceptual, and Physical Aspects of a Relational Database

Describing How a Relational Database Management System (RDBMS) Is Used to Manage a Relational Database

Describing the Oracle Implementation of Both the RDBMS and the Object Relational Database Management System (ORDBMS)

Describing How SQL Is Used in the Oracle Product Set

Describing PL/SQL

Describing the Use of PL/SQL for the Developer and the DBA

 

Writing a Basic SQL Statement

Describing the SQL Select Capabilities

Executing a Basic Select Statement with the Mandatory Clauses

Differentiating Between SQL and SQL*Plus Commands

 

Restricting and Sorting Data Limiting the Rows Retrieved by a Query

Sorting the Rows Retrieved by a Query

 

Single Row Functions Describing Various Types of Functions Available in SQL

Using a Variety of Character, Number, and Date Functions in SELECT Statements

Explaining What the Conversion Functions Are and How They Are Used

 

Displaying Data from Multiple Tables

Writing SELECT Statements to Access Data from More Than One Table

Describing the Cartesian Product

Describing and Using the Four Different Types of Join

Writing Joins Using the Tips Provided

 

Aggregating Data using Group Functions Identifying the Different Group Functions Available

Explaining the Use of Group Functions

Grouping Data Using the GROUP BY Clause

Including or Excluding Grouped Rows Using the HAVING Clause

 

Writing Subqueries

Describing the Types of Problems That Subqueries Can Solve

Describing What Subqueries Are

Listing the Types of Subqueries

Writing Single-Row and Multi-Row Subqueries

 

Multi-Column Subqueries

Writing a Multi-Column Subquery

Describing and Explaining the Behavior of Subqueries When NULL Values Are Retrieved

Writing a Subquery in a FROM Clause

 

Producing Readable Output with SQL*Plus Producing Queries that Require an Input Variable

Customising the SQL*Plus Environment

Producing More Readable Output

Creating and Executing Script Files

Saving Customisations

 

Manipulating Data Describing Each Data Manipulation Language (DML) Command

Inserting Rows into a Table

Updating Rows in a Table

Deleting Rows from a Table

Controlling Transactions

Describing Transaction Processing

 

Creating and Managing Tables

Describing the Main Database Objects

Creating Tables

Describing the Oracle7 Data types and the Oracle8 Data types

Altering Table Definitions

Dropping, Renaming, and Truncating Tables

 

Including Constraints

Describing Constraints

Creating and Maintaining Constraints

 

Creating Views

Describing Views and Their Uses

Creating a View

Retrieving Data Via a View

Inserting, Updating, and Deleting Data Through Views

Dropping Views

Altering the Definition of a View

Inline Views

Top ?N? Analysis

 

Other Database Objects Creating, Maintaining, and Using Sequences

Creating and Maintaining Indexes

Creating Private and Public Synonyms

 

Controlling User Access

Understanding the Concepts of Users, Roles, and Privileges

Granting and Revoking Object Privileges

Creating Roles and Granting Privileges to Roles

Creating Synonyms for Ease of Table Access

 

SQL Workshop Applying Techniques Learned in This Course

Preparing for Future Oracle Courses

 

Declaring Variables Recognizing the Basic PL/SQL Block and Its Sections

Describing the Significance of Variables in PL/SQL

Distinguishing Between PL/SQL and Non-PL/SQL Variables

Declaring Variables and Constants

Executing a PL/SQL Block

 

Writing Executable Statements

Recognizing the Significance of the Executable Section

Writing Statements Within the Executable Section

Describing the Rules of Nested Blocks

Executing and Testing a PL/SQL Block

Using Coding Conventions

 

Interacting with the Oracle Server Writing a Successful SELECT Statement in PL/SQL

Declaring the Data type and Size of a PL/SQL Variable Dynamically

Writing DML Statements in PL/SQL

Controlling Transactions in PL/SQL

Determining the Outcome of SQL DML Statements

 

Writing Control Structures Identifying the Uses and Types of Control Structures

Constructing an IF Statement

Constructing and Identifying Different Loop Statements

Controlling Block Flow Using Nested Loops and Labels

Using Logic Tables.

 

Oracle Architectural Components

Describing the Oracle Architecture and Its Main Components

Listing the Structures Involved in Connecting a User to an Oracle Instance

Listing the Stages in Processing: Queries, Data Manipulation Language (DML) Statements, and COMMITs

 

Getting Started with the Oracle Server

Identifying the Features of the Universal Installer

Setting Up Operating System and Password File Authentication

Listing the Main Components of Oracle Enterprise Manager and Their Uses

 

Managing an Oracle Instance

Creating the Parameter File

Starting Up an Instance and Opening the Database

Closing a Database and Shutting Down the Instance

Getting and Setting Parameter Values

Managing Sessions

Monitoring the ALERT File and Trace Files

 

Creating a Database

Preparing the Operating System

Preparing the Parameter File

Creating a Database

 

Data Dictionary Views and Standard Packages

Constructing the Data Dictionary Views

Querying the Data Dictionary

Preparing the PL/SQL Environment Using the Administrative Scripts

Administering Stored Procedures and Packages

Listing the Types of Database Event Triggers

 

Maintaining the Control File

Explaining the Use of the Control File

Listing the Contents of the Control File

Multiplexing the Control File

Obtaining Control File Information

 

Maintaining Redo Log Files

Explaining the Use of Online Redo Log Files

Obtaining Log and Archive Information

Controlling Log Switches and Checkpoints

Multiplexing and Maintaining Online Redo Log Files

Planning Online Redo Log Files

Troubleshooting Common Redo Log File Problems

Analyzing Online and Archived Redo Logs

 

Managing Tablespaces and Data Files

Describing the Logical Structure of the Database

Distinguishing the Different Types of Temporary Segments

Creating Tablespaces

Changing the Size of Tablespaces

Allocating Space for Temporary Segments

Changing the Status of Tablespaces

Changing the Storage Settings of Tablespaces

Relocating Tablespaces

 

Storage Structure and Relationships

Describing the Logical Structure of the Database

Listing the Segment Types and Their Uses

Listing the Keywords that Control Block Space Usage

Obtaining Information About Storage Structures from the Data Dictionary

Listing the Criteria for Separating Segments

 

Managing Rollback Segments

Creating Rollback Segments Using Appropriate Storage Settings

Maintaining Rollback Segments

Planning the Number and Size of Rollback Segments

Obtaining Rollback Segment Information from the Data Dictionary

Troubleshooting Common Rollback Segment Problems

 

Managing Tables

Creating Tables Using Appropriate Storage Settings

Controlling the Space Used by Tables

Analyzing Tables to Check Integrity and Migration

Retrieving Information About Tables from the Data Dictionary

Converting Between Different Formats of ROWID

 

Managing Indexes

Listing the Different Types of Indexes and Their Uses

Creating B*-Tree and Bitmap Indexes

Reorganizing Indexes

Dropping Indexes

Getting Index Information from the Data Dictionary

 

Maintaining Data Integrity

Implementing Data Integrity

Maintaining Integrity Constraints

Obtaining Constraint Information from the Data Dictionary

 

Loading Data

Loading Data Using Direct-Load Insert

Loading Data into Oracle Tables Using SQL*Loader

Conventional

Direct Paths

 

Reorganizing Data

Reorganizing Data Using Export and Import

Moving Data Using Transportable Tablespaces

 

Managing Password Security and Resources

Managing Passwords Using Profiles

Administering Profiles

Controlling Use of Resources Using Profiles

Obtaining Information About Profiles, Password Management, and Resources

 

Managing Users

Creating New Database Users

Altering and Dropping Existing Database Users

Monitoring Information About Existing Users

 

Managing Privileges

Identifying System and Object Privileges

Granting and Revoking Privileges

Controlling Operating System or Password File Authentication

Identifying Auditing Capabilities

 

Managing Roles

Creating and Modifying Roles

Controlling Availability of Roles

Removing Roles

Using Predefined Roles

Displaying Role Information from the Data Dictionary

 

Using National Language Support

Choosing Character Set and National Language Character Set for a Database

Specifying the Language-Dependent Behavior Using Initialization Parameters, Environment Variables, and the ALTER SESSION Command

Using Different Types of NLS Parameters

Obtaining Information About NLS Usage

 

Backup and Recovery Considerations

Defining business, operational, and technical requirements for a Backup and Recovery Strategy

Understanding the importance of obtaining management concurrence for a Backup and Recovery Plan

Identifying the components of a Disaster Recovery Plan

Listing advantages and disadvantages of possible database configurations that support Recoverability

Discussing the importance of testing a Backup and Recovery Strategy

 

Oracle Recovery Structures and Processes

Describing the Oracle Processes, File Structures, and Memory Components

Observing the importance of Checkpoints, Redo Logs, and Archives

Multiplexing Control Files and Redo Logs

Describing Bounded Recovery Time

Listing the types of failure that may occur in an Oracle Database Environment

Describing the structures for Instance and Media Recovery

Describing the concept of Deferred Transaction Recovery Parallelism on Demand

 

Oracle Backup and Recovery Configuration

Configuring a database in Noarchivelog Mode

Configuring a database in Archivelog Mode

Configuring Multiple Archival (of Redo Log) Processes

Remote Archival of Redo Logs

Performing Manual Archive of Log Files

Enabling/Disabling Automatic Archiving

Configuring multiple Archival Destinations and Processes

 

Physical Backup Without RMAN

Describing the recovery implications of Closed and Opened Database Backups

Performing backup of Closed Database

Performing backup of Opened Database in Archivelog Mode

Identifying the backup implications of Operations with

Performing backup of Control Files using Different Methods

Discussing backup Issues Associated with

Listing the Data Dictionary Views useful for Backup Operations

 

Complete Recovery of an Oracle Database

Noting implications of media failure with a database in Noarchivelog Mode

Recovering (Restoring) a database in Noarchivelog Mode after Media Failure

Noting implications of Instance Failure with an Archivelog Mode Database

Describing a Complete Recovery Operation

Performing recovery of a database in Archivelog Mode after Media Failure

 

Incomplete Recovery of an Oracle Database with Archiving

Identifying the situations to use an Incomplete Recovery to Recover the Database

Performing an Incomplete Database Recovery

Recovering after Losing Current and Active Redo Log Files

Describing and Performing a Tablespace-Point-in-Time Recovery

 

Oracle Export/Import Utilities

Using the Export Utility to create a Complete Logical Backup of a Database Object

Using the Export Utility to create an incremental backup of a Database Object

Invoking direct-path method export

Export and Transportable Tablespaces

Using the Import Utility to Recover a Database Object

 

Additional Recovery Issues

Starting Oracle with Missing Data Files

Parallelizing Recovery Operation

Recovering Read-Only Tablespaces

Recovering from Loss of Control Files

Recovering with Missing Data Files Backup

 

Oracle Utilities for Troubleshooting

Early detection of block corruption

Using DBMS_REPAIR for recovering a Table/Index with Block Corruption

Using the DBVERIFY utility to validate the structure of an Oracle Database File

Using LOGMINER to analyze the Log Files

Configuring Checksum Operations

Using Log and Trace Files to diagnose problems associated with Backup and Recovery Operations

 

Oracle Recovery Manager Architecture

Components of RMAN

Advantages of RMAN

Command interface to Stop and Start Database

Content of Recovery Catalog

Media Management Layer and Tape Catalog

Connecting to Recovery Manager

 

Oracle Recovery Catalog Maintenance

Creating a Recovery Catalog

Using Recovery Manager to register, resynch, and reset a database

Maintaining the Recovery Catalog using change, delete, and catalog Commands

Querying the Recovery Catalog to generate reports and lists

Creating and Executing scripts to perform Backup and Recovery Operations

Creating, storing, and running scripts

 

Physical Backups Using RMAN

Identifying types of RMAN Backups

Describing backup concepts using RMAN

Performing Incremental and Cumulative Backups

Troubleshooting Backup Problems

Viewing Information from the Data Dictionary

 

Restore and Recover Using RMAN

Restoring a Database in Noarchivelog Mode

Restoring a Tablespace in an Opened Database

Relocation of Data Files: Recovering from Disk Corruption

Incomplete Recovery of a Database

 

Oracle Standby Database

Explaining the use of a Standby Database

Configuring Initialization Parameters

Creating, maintaining, and activating a Standby Database

Understanding the effects of changing the structure of the Primary Database

Observing the impact of Nologging Actions on the Primary Database

Listing the steps to configure the Archival to a Standby Database

Configuring to have Sustained Recovery of Standby Database

Describing the steps to setup the Standby Database in Read-Only Mode

 

Oracle Performance Tuning Methodology

Listing the different roles associated with the tuning process

Defining the steps associated with the tuning process

Identifying different tuning goals

 

Oracle Alert and Trace Files

Identifying the location and usefulness of the alert log file

Identifying the location and usefulness of the background and user process trace files

 

Utilities and Dynamic Performance Views

Collecting statistics using the dynamic troubleshooting and performance views

Diagnosing statistics using the UTBSTAT/UTLESTAT output report

Identifying the different types of latches

Retrieving and displaying wait events

Setting events through OEM to be alerted about predefined situations

Using appropriate OEM tuning tools

 

Tuning the Shared Pool

Tuning the library cache and data dictionary cache

Measuring the shared pool hit percentage

Sizing the shared pool appropriately

Pinning objects in the shared pool

Tuning the shared pool reserved space

Listing the UGA and session memory considerations

 

Tuning the Buffer Cache

Describing the how the buffer cache is managed

Calculating the buffer cache hit ratio

Examining the impact of adding or removing buffers

Creating multiple buffer pools

Sizing multiple buffer pools

Monitoring buffer cache usage

Making appropriate use of table caching

Identifying performance issues associated with buffer cache latches

 

Tuning the Redo Log Buffer

Determining if processes are waiting for space in the redo log buffer

Sizing the redo log buffer appropriately

Reducing redo operations

Identifying performance issues associated with the redo buffer latches

 

Database Configuration and I/O Issues

Diagnosing inappropriate use of SYSTEM, RBS, TEMP, DATA and INDEX tablespaces

Detecting I/O problems

Ensuring that files are distributed to minimize I/O contention

Using striping where appropriate

Tuning checkpoints

Tuning background process I/O

 

Using Oracle Blocks Efficiently

Determining an appropriate block size

Optimizing space usage within blocks

Detecting and resolving row migration

Monitoring and tuning indexes

Appropriately sizing extents

 

Optimizing Sort Operations

Identifying the SQL operations that require sorts

Ensuring that sorting is done in memory where possible

Allocating temporary space appropriately

 

Rollback Segment Tuning

Using the dynamic performance views to check rollback segment performance

Reconfiguring and monitoring rollback segments

Defining the number and sizes of rollback segments

Allocating rollback segments to specific transactions

 

Monitoring and Detecting Lock Contention

Defining the levels of Oracle locking

Listing possible causes of lock contention

Using Oracle utilities to diagnose lock contention

Resolving contention in an emergency

Preventing locking problems

Recognizing Oracle errors arising from deadlocks

 

SQL Issues and Tuning Considerations for Different Applications

Identifying the role of the DBA in application tuning

Using optimizer modes to enhance SQL statement performance

Managing stored outlines to store execution paths as a series of hints

Using the available data access methods to tune the physical design of the database. Identify the demands of online transaction processing systems (OLTP).

Identify the demands of decision support system.

 

Managing Mixed Workload

Resource Management Concepts

Steps in Database Resource Management

Dictionary View

 

Tuning with Oracle Expert

Listing the features of Oracle Expert

Creating a tuning session

Gathering, viewing, and editing the input data

Analyzing the collected data using rules

Reviewing tuning recommendations

Implementing tuning recommendations

 

Multithreaded Server Tuning Issues (Optional)

Identifying issues associated with managing users in a multithreaded server environment

Diagnosing and resolving performance issues with multithreaded server processes

Configuring the multithreaded server environment to optimize performance

 

Use a tuning methodology to diagnose and resolve performance tuning issues

Using Oracle tools to diagnose performance problems

Tuning memory structures, file I/O, and contention

 

 

 

 

É dífícil virar DBA viu.......... todos sofrem... hehehehehehehe http://forum.imasters.com.br/public/style_emoticons/default/grin.gif :rolleyes:

[alphamek 2]

Antigamente, para versões 8i, era aplicada 5 provas.

 

Todas as provas que mencionei acima, e mais uma de Network Administration.

 

Os centros de treinamentos não aplicam mais provas em 8i, pelo menos São Paulo, agora é só 10g e 9i. http://forum.imasters.com.br/public/style_emoticons/default/shifty.gif

 

Abraços,

[M4cJun1or 0]

Antigamente, para versões 8i, era aplicada 5 provas.

 

Todas as provas que mencionei acima, e mais uma de Network Administration.

 

Os centros de treinamentos não aplicam mais provas em 8i, pelo menos São Paulo, agora é só 10g e 9i.  http://forum.imasters.com.br/public/style_emoticons/default/shifty.gif

 

Abraços,

<{POST_SNAPBACK}>

Certificaão Oracle Sales Champion 10g

Você sabia que as provas para o Oracle Sales Champion 10g estão em português?

[alphamek 2]

O que é Oracle Sales Champion 10g? Algum módulo de Vendas do bussiness 11i ou do ERP novo da Oracle. hehehehehehehehehehehe... :blink:

[Fujihara 0]

Ehhh???? http://forum.imasters.com.br/public/style_emoticons/default/assobiando.gif

 

Por acaso eu preciso fazer os cursos da Oracle para tirar as certificações ou posso estudar por conta e fazer apenas as provas?

[rick_simmons 0]

Se quiser estudar por conta própria então muito boa sorte nos estudos hehehe pois vai ter que se dedicar MUITO lendo mais de 1500 páginas com explicações técnicas hehehe

[M4cJun1or 0]

Se quiser estudar por conta própria então muito boa sorte nos estudos hehehe pois vai ter que se dedicar MUITO lendo mais de 1500 páginas com explicações técnicas hehehe

<{POST_SNAPBACK}>

Pois é cara... e tem empresas como a minha que tem coragem de falar com a boca cheia de água... Estuda ae que eu pago a prova...

hauhauhuahahuhauhauhauhuahuahuhauhahuahuahu....

Aff...

Fala sério!!!

[rick_simmons 0]

eu não sei se é verdade mas me falaram que o curso preparatório para a certificação são 10 módulos que custam mais de mil reais cada... um absurdo

[alphamek 2]

Sobre os módulos de 10g, é com certeza.

 

E o resto... é sorte... para tirar o OCP é decoreba. Na prática, aplica-se poucos dos conceitos.

 

Abraços,

 

http://forum.imasters.com.br/public/style_emoticons/default/clap.gif

[Fernando Lopes RN 0]

Pessoal, Alguem poderia indicar um livro para estudo para Certificação OCA 10g ?

Grato

[alphamek 2]

Compre o livro All-in-Exam para 10g, ele te prepara para OCA e OCP e vêm com um CD de simulados.

 

A Editora é Oracle Press.