Synopsis Oracle9i Database Fundamentals 1Z1-031: Managing Instances and Creating Databases introduces users to managing an Oracle instance, creating a database, and using globalization parameters.
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: OR3102
Oracle9i Database Fundamentals 1Z1-031: Managing Instances and Creating Databases covers the following topics:
Creating an Initialization Parameter File
Configuring Oracle-Managed Files
Starting an Instance using SQL*Plus
Startup Methods and Options
Shutting Down an Instance
Using Diagnostic Files
Planning for Database Creation
Preparing the Parameter File
Using the Database Configuration Assistant
Creating a Database Manually
Choosing a Character Set
Specifying Language-Dependent Behavior
Viewing Globalization Support Information
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 the Database Structure (OR3103)
Oracle9i Database Fundamentals 1Z1-031: Managing Tablespaces and Datafiles (OR3104)
Oracle9i Database Fundamentals 1Z1-031: Managing Storage Structures and Undo Data (OR3105)