Oracle9i Database Fundamentals 1Z1-031

Synopsis
Oracle9i Database Fundamentals 1Z1-031: Managing the Database Structure introduces users to data dictionaries, control files, and redo log files.

Audience
This course is for anyone preparing for the Oracle 1Z1-031: Oracle9i DBA Fundamentals I exam, or anyone who wants an introduction to Oracle database fundamentals.

Time
3 hours

Product Code: OR3103

Oracle9i Database Fundamentals 1Z1-031: Managing the Database Structure covers the following topics:

Constructing Data Dctionary Vews

Tables and Views

Data Dictionary Contents

Querying the Data Dictionary

Using Control Files

Control File Contents

Using Oracle-Managed Files

Viewing Control File Information

Multiplexing Control Files

Redo Log Files

Controlling Log Switches and Checkpoints

Maintaining Redo Log Files

Using OMF to Manage Redo Log Files

This course has the following features:

Exercises that allow users to practice in Oracle9i

A file containing the text of the exercises

Activities that allow users to apply course concepts in an interactive questioning environment

A glossary

A Skill Assessment

Familiarity with relational databases, SQL, and networking

Oracle9i Database Fundamentals 1Z1-031: Oracle Architecture and Tools (OR3101)

Oracle9i Database Fundamentals 1Z1-031: Managing Instances and Creating Databases (OR3102)

Oracle9i Database Fundamentals 1Z1-031: Managing Tablespaces and Datafiles (OR3104)

Oracle9i Database Fundamentals 1Z1-031: Managing Storage Structures and Undo Data (OR3105)

Oracle9i Database Fundamentals 1Z1-031: Managing Tables (OR3106)

Oracle9i Database Fundamentals 1Z1-031: Managing Indexes and Data Integrity (OR3107)

Oracle9i Database Fundamentals 1Z1-031: Managing Users and Profiles (OR3108)

Oracle9i Database Fundamentals 1Z1-031: Managing Privileges and Roles (OR3109)

Oracle9i Database Fundamentals 1Z1-031: Exam Preparation (OR3110)

Oracle® and Oracle9i™ are trademarks of Oracle Corporation.

Get more out of your Software
Improve your Skills
Prepare for Certification
Save time every time and reduce frustration.

Our online training material lets you:
TEST your skills
LIST the areas where you need additional training
Take lessons that TEACH SKILLS to improve these areas
Tests your skills again

NO HIDDEN CHARGES.
NO SETUP or SHIPPING CHARGES.
NO ads or banners in the training material.
No selling of your personal information, no email lists.
Just 100% Quality Training at one low price.

Repeat the courses as often as you need, you have 12 months of unlimited access and can view your scores anytime so you can easily track your progress.

Our training is tested and guaranteed to provide RESULTS and save you TIME.

All courseware is online 24 hours a day.
Our courseware is optimized so content delivery is fast even with a 28.8 modem connection.
If you can get on the Internet you can access the training, ANYWHERE, ANYTIME.