|Oracle 10g OCA|

Training at Nhames Limited is a wonderful experience.

ORACLE 10g OCA Certification Exam and Courses Highlight:

Database Administrator: Database Administrators are responsible for administrative activities like installing database, taking backups, managing and fine-tuning performance over the network, and data recovery. They have the knowledge of basic architecture of the Oracle database.

ORACLE 10g OCA Certification Exam and Courses Highlight:

Oracle OCA

Exam #1Z0-042 Oracle Database 10g: Administration I

Oracle OCA Certification Course Highlight

Oracle 10g OCA certification

Course Contents

Installing Oracle Database 10g Software

Identify system requirements for Oracle 10g server

Use Optimal Flexible Architecture

Install software with Oracle Universal Installer

Identify and configure commonly used environment variables in Oracle database

Creating an Oracle 10g Database

Explain the Oracle database architecture

Explain the instance architecture in Oracle 10g Database

Use the management framework

Use DBCA to Create a Oracle 10g database

Use DBCA to Configure a Oracle 10g database

Use DBCA to Drop a Oracle database

Use DBCA to Manage templates

Oracle 10g Database Interfaces

Use SQL*Plus and iSQL*Plus to access the Oracle Database 10g

Use SQL*Plus and iSQL*Plus to describe the logical structure of tables

Use SQL to query, manipulate, and define data using SELECT, UPDATE/INSERT/DELETE and CREATE/ALTER/DROP statements

Identify common database interfaces

Describe a database transaction

Controlling the Oracle Database

Start and stop iSQL*Plus

Start and stop Enterprise Manager Database Control

Start and stop the Oracle Listener

Start up and shut down Oracle Database 10g

Describe startup and shutdown options for the Oracle Database

Handle Parameter files

Locate and view the Database alert log

Storage Structures in Oracle Database

Define the purpose of tablespaces and data files

Create tablespaces in Oracle 10g database

Manage tablespaces (alter, drop, generate DDL, take offline, put on line, add data files, make read-only/read-write)

Obtain tablespace information from EM and the data dictionary

Drop tablespaces

Describe the default tablespaces

Managing Schema Objects in Oracle

Create and modify tables in Oracle

Define constraints in Oracle

View the attributes of a table in Oracle database

View the contents of a table

Create indexes and views in Oracle database

Name database objects in Oracle

Select appropriate data types

Create and use sequences in Oracle

Managing Oracle Data

Manipulate data through SQL using INSERT, UPDATE, and DELETE

Use Data Pump to export data

Use Data Pump to import data

Load data with SQL Loader

Create directory objects

Oracle PL/SQL

Identify PL/SQL objects

Describe triggers and triggering events

Identify configuration options that affect PL/SQL performance

Oracle Database Security

Apply the principal of least privilege

Manage default user accounts

Implement standard password security features in Oracle

Audit Oracle database activity

Register for security updates

Oracle Net Services

Use Database Control to Create additional listeners

Use Database Control to Create Oracle Net service aliases

Use Database Control to Configure connect time failover

Use Listener features in Oracle 10g

Use the Oracle Net Manager to configure client and middle-tier connections

Use TNSPING to test Oracle Net connectivity

Describe Oracle 10g Net Services

Describe Oracle Net names resolution methods

Oracle Shared Servers

Identify when to use Oracle Shared Servers

Configure Oracle Shared Servers

Monitor Shared Servers

Describe the shared server architecture

Oracle Performance Monitoring

Troubleshoot invalid and unusable objects

Gather optimizer statistics

View performance metrics

React to performance issues

Proactive Maintenance

Set warning and critical alert thresholds

Collect and use baseline metrics

Use tuning and diagnostic advisors

Use the Automatic Database Diagnostic Monitor (ADDM)

Manage the Automatic Workload Repository

Describe server generated alerts

Oracle Undo Management

Monitor and administer undo in Oracle 10g

Configure undo retention

Guarantee undo retention

Use the Undo Advisor

Describe the relationship between undo and transactions

Size the undo tablespace in Oracle 10g

Monitoring and Resolving Lock Conflicts

Detect and resolve lock conflicts

Manage deadlocks

Describe the relationship between transactions and locks

Explain lock modes within the Oracle Database 10g

Oracle 10g Backup and Recovery Concepts

Describe the basics of database backup, restore and recovery

Describe the types of failure that may occur in an Oracle Database

Describe ways to tune instance recovery

Identify the importance of checkpoints, redo log files, and archived log files

Configure ARCHIVELOG mode

Configure a database for recoverability

Oracle 10g Database Backups

Create consistent database backups

Back up your database without shutting it down

Create incremental backups

Automate database backups

Monitor the flash recovery area

Describe the difference between image copies and backup sets

Describe the different types of database backups

Backup a control file to trace

Manage backups

Oracle 10g Database Recovery

Recover from loss of a Control file

Recover from loss of a Redo log file

Recover from loss of a system-critical data file

Recover from loss of a non system-critical data file

Why Train with us :