Oracle8i Database Admin Create Databases

This course is the second 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 storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered.

Learn To:

• Identify and create a database.
• Identify the data dictionary views.
• Identify the data dictionary views to retrieve information.
• Identify the scripts to set up the PL/SQL environment.
• Identify control files
• Identify redo log files
• Identify tablespaces and data files.

Content Emphasis

Skills-Based

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). This course will help candidates prepare for the Oracle8i Certified DBA Architecture and Administration exam 1Z0-023.

Total Learning Time

6 - 8 Hour(s)

Unit 1: Creating a Database: Procedure

• Identify the guidelines for creating an OFA structure.
• Match the ORACLE_HOME subdirectories with their contents.
• Identify the factors to be considered when creating a database.
• Identify the requirements for creating a database.
• Identify the guidelines to be followed for planning a physical database design.
• Identify the steps involved in manually creating a database.
• Identify the registry entries that have to be specified for proper database functionality.
• Create a specified password file for a given instance by using the ORADIM80 utility.
• Create a specified parameter file by editing specific settings in the default init.ora file.
• Start a specified instance in the NOMOUNT mode by using Oracle SQL*Plus Worksheet.
• Identify the functionality of the CREATE DATABASE command options.
• Create a database with specified parameter values by using the CREATE DATABASE command.
• Identify the commonly encountered situations in which the CREATE DATABASE command fails.
• Identify the contents of a database after its creation.

Unit 2: Data Dictionary Views and Standard Packages

• Identify the types of information stored in the data dictionary.
• Identify the features of the data dictionary components.
• Create a data dictionary view for a specific database by executing the appropriate script.
• Identify the contents of the data dictionary view categories.
• Retrieve specific information by querying the Dictionary view.
• Create PL/SQL functionality for a specific database by executing the appropriate script.
• Match the administrative script categories with the views and package components they create.
• Identify the properties of stored procedures.
• Identify the properties of packages.
• Identify the benefits of stored program units.
• Match the Oracle-supplied packages with their functions.
• Retrieve information about invalid objects in a specified database by querying the required data dictionary view.
• Retrieve information about a stored program unit specification by using the Oracle SQL*Plus Worksheet.
• Identify the common situations when dependent objects may have an invalid status.

Unit 3: Maintaining Redo Log Files and Control Files

This is primarily online training This is an online eLearning or CBT training program This program may be available on CD

Training Presented in: English