Oracle9i Database Fundamentals 1Z0-031 Online Training Course
Course Topics: 10
Estimated Time Needed: 29 hour(s)
Audience: This training course is for anyone preparing for the Oracle 1Z0-031: Oracle9i DBA Fundamentals I exam, or anyone who wants an introduction to Oracle database fundamentals.
Course Description: This online course is designed to help users who have experience with relational databases, SQL, and networking prepare for the Oracle 9i 1Z0-031 exam. Users will be introduced to the major components of an Oracle server and the database structure, and will learn how to create and manage such components as databases, instances, tablespaces, tables, datafiles, storage units, undo data, tables, indexes, data integrity, users, profiles, privileges, and roles.
Course Tutorials Include:
Oracle9i Database Fundamentals 1Z0-031: 1 Oracle Architecture and Tools
Description
This course introduces users to the major components of an Oracle server.
Objectives
- Explain the Oracle server architecture
- Identify how users connect to the Oracle server
- List tools used by DBAs to administer Oracle
- Describe the benefits of Optimal Flexible Architecture
- Install Oracle using Oracle Universal Installer
Oracle9i Database Fundamentals 1Z0-031: 2 Managing Instances and Creating Databases
Description
This course introduces users to managing an Oracle instance, creating a database, and using globalization parameters.
Objectives
- Create and manage an initialization parameter file
- Configure Oracle-managed files
- Use the startup command
- List the different options available for starting Oracle
- Shut down an Oracle instance
- Describe the two types of diagnostic files used in Oracle
- List the prerequisites necessary for database creation
- List values that must be set in the parameter file
- Use the Database Configuration Assistant
- Create a database with the create database command
- Define a character set for your database
- Configure language-dependent behavior for the your database
- Retrieve NLS information from the your database
Oracle9i Database Fundamentals 1Z0-031: 3 Managing the Database Structure
Description
This course introduces users to data dictionaries, control files, and redo log files.
Objectives
- Use data dictionary views
- Query the data dictionary
- Use control files
- Work with redo logs
Oracle9i Database Fundamentals 1Z0-031: 4 Managing Tablespaces and Datafiles
Description
This course introduces users to creating and managing tablespaces.
Objectives
- Describe the logical structure of Oracle databases
- Create tablespaces
- Manage temporary segments
- Take tablespaces online and offline
- Change tablespace storage settings
- Use Oracle-Managed Files (OMF) with tablespaces
Oracle9i Database Fundamentals 1Z0-031: 5 Managing Storage Structures and Undo Data
Description
This course introduces users to the underlying storage structure of a database and to using undo segments.
Objectives
- Identify storage needs for different segment types
- Control the size allocation of extents and segments
- Acquire extents in dictionary-managed tablespaces
- Use multiple extents when using parallel processors
- List the keywords that control block space usage
- Obtain information about storage from the data dictionary
- Describe the purpose of undo data
- Implement automatic undo management
- Create and configure undo segments
- Size OLTP and batch undo segments
- Maintain undo segments manually
Oracle9i Database Fundamentals 1Z0-031: 6 Managing Tables
Description
This course introduces users to creating and managing table structures.
Objectives
- Explain how tables can store data
- Create permanent and temporary tables
- Manage storage structures
- Relocate tables
- Drop unused columns
Oracle9i Database Fundamentals 1Z0-031: 7 Managing Indexes and Data Integrity
Description
This course introduces users to indexes and data integrity constraints.
Objectives
- Describe the different types of indexes and their uses
- Create various types of indexes
- Reorganize and drop indexes
- Monitor index usage
- Implement data integrity constraints
- Maintain integrity constraints
- Obtain index and constraint information from the data dictionary
Oracle9i Database Fundamentals 1Z0-031: 8 Managing Users and Profiles
Description
This course introduces users to creating and managing users and to control resources using profiles.
Objectives
- Create new database users
- Manage existing users
- Monitor information about existing users
- Control resource use with profiles
- Administer profiles
- Manage passwords using profiles
- Obtain profile information from the data dictionary
Oracle9i Database Fundamentals 1Z0-031: 9 Managing Privileges and Roles
Description
This course introduces users to system and object privileges and user roles.
Objectives
- Identify system and object privileges
- Grant and revoke privileges
- Identify auditing capabilities
- Create and modify roles
- Control availability of roles
- Remove roles
- Use predefined roles
- Display role information from the data dictionary
Oracle9i Database Fundamentals 1Z0-031:10 Exam Preparation
Description
This course allows users to practice answering questions in order to prepare for taking the exam.
Objectives
- After completing this course, the user should be familiar with all the exam objectives for the Oracle 1Z1-031: Oracle9i DBA Fundamentals I exam

Features
- Activities allow learners to apply course concepts in an interactive questioning environment.
- Exercises allow learners to practice in the actual application being studied.
- A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
- Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
- Search text enables learners to rapidly search all text within a course to easily retrieve information required.
- Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
- A skill assessment generates a customized learning path based on the results of a pre-test.
- A glossary provides a reference for definitions of unfamiliar terms.
- Bookmarking tracks the learner's progress in a course.
- A file containing the text of the exercises.