Oracle8i Database Administration: Manage Data Storage

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.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

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.

Objective

• 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 indexorganized tables (IOTs).
• Identify and reorganize data.

Topics Include

Unit 1: Managing Tables

• Identify the information stored in a table row.
• Identify the features of the built-in scalar data types.
• Identify the components of the ROWID format.
• Identify the characteristics that distinguish VARRAYs from nested tables.
• 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.
• Identify the situations in which the row chaining and row migration events are triggered.
• Copy a table by using Oracle Schema Manager.
• Identify the storage parameters that when modified 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 of a table.
• Deallocate 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.
• Drop unused columns from a table.
• 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

• 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.
• Identify the procedure followed by the Oracle server to implement unique and primary keys.
• Identify the factors to be considered while performing DDL operations on the tables referenced by a foreign key.
• Identify the factors to be considered while performing DML operations on the foreign key-primary key related tables.
• Match the types of database triggers with the situations in which they are executed.
• Disable triggers by using Oracle SQL*Plus Worksheet.
• Enable triggers by using Oracle SQL*Plus Worksheet.
• Create an inline constraint using Oracle SQL*Plus Worksheet.
• Create an out-of-line constraint by using Oracle SQL*Plus Worksheet.
• Identify the guidelines for defining constraints.
• Disable constraints by using Oracle SQL*Plus Worksheet.
• Disable constraints in the validate mode by using Oracle SQL*Plus Worksheet.
• Enable a constraint in the novalidate mode by using Oracle SQL*Plus Worksheet.
• Enable constraints in the validate mode by using Oracle SQL*Plus Worksheet.
• Sequence the steps required for detecting constraint violations by using the EXCEPTIONS table.
• Drop constraints by using Oracle SQL*Plus Worksheet.
• Drop triggers by using Oracle Schema Manager.
• Identify the contents of the data dictionary views used for retrieving constraint information.
• Identify the data dictionary views to be used for retrieving specified information about triggers.

Unit 3: Clusters and Index-Organized Tables

• Match the methods for loading data into tables with their functions.
• Perform a serial direct load insert by using Oracle SQL*Plus Worksheet.
• Perform parallel direct load inserts by using the PARALLEL hint.
• Identify the features of SQL*Loader.
• Match the input files used by SQL*Loader with their purposes.
• Match the output files used by SQL*Loader with their purposes.
• Identify the differences between the conventional and direct path load data loading methods.
• Sequence the steps that occur when parallel direct load sessions are initiated to load data into a table.
• Identify the guidelines to minimize errors and maximize the performance of SQL*Loader.
• Load data into a table by using Oracle Schema Manager.
• Identify the methods of troubleshooting the problems that may occur during a SQL*Loader data load.

Unit 4: Loading and Reorganizing Data

• Identify the uses of the Export and Import utilities.
• Identify the objects that can be exported using different export modes.
• Identify the features of the export data paths.
• Match the command line parameters for the Export utility with their purposes.
• Match the command line parameters for the Import utility with their purposes.
• Identify the guidelines for using the Export and Import utilities.
• Export objects by using Oracle Data Manager.
• Import objects by using Oracle Data Manager.
• Identify the characteristics of the import process.
• Identify the NLS considerations for exporting and importing objects.
• Identify the features of a transportable tablespace.
• Sequence the steps required to transport a tablespace to another database.
• Identify the restrictions for transporting a tablespace.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

• Oracle8i Database Administration: Create a Database
• Oracle8i Database Administration: Manage an Instance
• Oracle8i Database Administration: Manage Security
• Oracle8i Database Administration: Manage Storage Structures