|
Provided by: 123-CBT Computer Based Training Oracle8i Database Admin Manage Data Storage |
 |
Course Overview
This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.
Learn To:
- Identify the characteristics of various tables and datatypes.
- Identify and manage tables.
- Identify the characteristics and types of triggers and constraints.
- Identify and maintain data integrity.
- Identify clusters and index-organized tables (IOTs).
- Identify and reorganize data.
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), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i Database Administration: Create a Database (63312) and Oracle8i Database Administration: Manage Storage Structures (63313). 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: Managing Tables
Duration: 1 - 2 Hour(s)- Identify the row storage method for various types of tables.
- Identify the information stored in the components of the Oracle row structure.
- Identify the features of the Oracle built-in scalar datatypes.
- Identify the differences between the two large object datatypes.
- Identify the features of ROWID.
- Identify the components in a ROWID format.
- Identify the characteristics that distinguish the two collection datatypes.
- Create a table by using Oracle Schema Manager.
- Identify the guidelines to be followed while creating tables.
- Identify the value for the PCTFREE parameter in a given situation.
- Match the row chaining and row migration events with the situations that trigger them.
- Copy an existing table by using Oracle Schema Manager.
- Identify the storage parameters that when modified will affect a table.
- Identify the block utilization parameters that when modified affect the table blocks.
- Modify the storage and block parameters of a table by using Oracle Schema Manager.
- Manually allocate extents by using Oracle SQL*Plus Worksheet.
- Identify the characteristics of the high water mark.
- Validate a table structure by using Oracle SQL*Plus Worksheet.
- Execute the command used to detect row migration in a table by using Oracle SQL*Plus Worksheet.
- De-allocate the unused space in a table by using Oracle SQL*Plus Worksheet.
- Truncate a table by using Oracle SQL*Plus Worksheet.
- Identify the effects of truncating a table.
- Drop a table by using Oracle Schema Manager.
- Retrieve table information by using Oracle SQL*Plus Worksheet.
- Retrieve the extent information from DBA_EXTENTS by using Oracle SQL*Plus Worksheet.
- Obtain the physical location of the rows in a table by using Oracle SQL*Plus Worksheet.
Unit 2: Maintaining Data Integrity
Duration: 1 - 2 Hour(s)- Identify the features of integrity constraints.
- Identify the functions of the various types of declarative integrity constraints.
- Identify the data processing procedure for various constraint states.
- Match the deferred and immediate constraints with their features.
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
