User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
Oracle9i Database Fundamentals 1Z0-031 Series: Managing Instances and Creating Databases
Product Code: or3102 Time: 3.0 hour(s) CEUs: Available

Summary:

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


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

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright � 2006 Webteks. All rights reserved.