|
Provided by: 123-CBT Computer Based Training Oracle8i Database Admin Manage an Instance |
 |
Course Overview
This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support.
Learn To:
- Identify Oracle architectural components.
- Use the Oracle Enterprise Manager (OEM) interface.
- Manage an Oracle instance.
- Use National Language Support (NLS).
Content Emphasis
Skills-Based
Audience
Database Administrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Oracle Architecture Components
Duration: 1 - 2 Hour(s)- Identify the tasks of a database administrator.
- Match the terms associated with establishing a database connection with their descriptions.
- Identify the characteristics of a user process.
- Identify the characteristics of a server process.
- Match the memory structures of the System Global Area (SGA) with the information stored by them.
- Match the mandatory background processes with their functions.
- Match the different types of files existing in a database with the information stored in them.
- Match the non-database files with the information stored in them.
- Sequence the stages in processing a query.
- Identify the combinations of the shared pool components and the information stored in them.
- Identify the characteristics of the database buffer cache.
- Match the contents of the Program Global Area (PGA) with their uses.
- Identify the steps in the execute phase of a given DML statement.
- Identify the uses of a rollback segment.
- Identify the characteristics of a redo log buffer.
- Identify the events that cause the Database Writer (DBWR) to write to data files.
- Identify the events that cause the Log Writer (LGWR) to write to the redo log file.
- Identify the uses of System Change Numbers.
- Sequence the steps that occur during COMMIT processing.
- Identify the advantages of the fast COMMIT process used by Oracle.
Unit 2: Administration Tools
Duration: 1 - 2 Hour(s)- Match the tools used by the DBA with the administrative tasks that they enable the DBA to perform.
- Specify the associated command for a given description.
- Identify the features of the Oracle Enterprise Manager (OEM) architectural components.
- Match the OEM console components with the tasks that they enable.
- Identify the OEM console service used to perform a given task.
- Match the OEM standard applications with the tasks that they enable you to perform.
- Match the components of the Performance Pack with their functions.
- Identify the steps performed to set up OEM for use.
- Match the application interface objects with their uses.
- Match the SQL Worksheet components with their uses.
Unit 3: Managing an Oracle Instance
Duration: 2 Hour(s)- Identify the characteristics of the default database administrator user accounts.
- Set up the OS authentication on the NT platform.
- Set up a Password File Authentication on a NT platform by using the appropriate uti
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
