Architecture and Administration (1Z0-023)

This course is designed to give the Oracle database administrator (DBA) a firm foundation in basic administrative tasks and provide the necessary knowledge and skills to set up, maintain, and troubleshoot an Oracle7, Oracle8, or Oracle8i database. The student learns to startup and shutdown a database, create a database, manage file and database storage, and manage users and their privileges.

In addition, you will learn to organize the database and to move data into and between databases, under different environments. This section is preparation for the Oracle Database Administrator certification exam 1ZO-023.

Oracle Architectural Components

Describing the Oracle Architecture and Its Main Components
Listing the Structures Involved in Connecting a User to an Oracle Instance
Listing the Stages in Processing: Queries, Data Manipulation Language (DML) Statements, and COMMITs

Getting Started with the Oracle Server

Identifying the Features of the Universal Installer
Setting Up Operating System and Password File Authentication
Listing the Main Components of Oracle Enterprise Manager and Their Uses

Managing an Oracle Instance

Creating the Parameter File
Starting Up an Instance and Opening the Database
Closing a Database and Shutting Down the Instance
Getting and Setting Parameter Values
Managing Sessions
Monitoring the ALERT File and Trace Files

Creating a Database

Preparing the Operating System
Preparing the Parameter File
Creating a Database

Data Dictionary Views and Standard Packages

Constructing the Data Dictionary Views
Querying the Data Dictionary
Preparing the PL/SQL Environment Using the Administrative Scripts
Administering Stored Procedures and Packages
Listing the Types of Database Event Triggers

Maintaining the Control File

Explaining the Use of the Control File
Listing the Contents of the Control File
Multiplexing the Control File
Obtaining Control File Information

Maintaining Redo Log Files

Explaining the Use of Online Redo Log Files
Obtaining Log and Archive Information
Controlling Log Switches and Checkpoints
Multiplexing and Maintaining Online Redo Log Files
Planning Online Redo Log Files
Troubleshooting Common Redo Log File Problems
Analyzing Online and Archived Redo Logs

Managing Tablespaces and Data Files

Describing the Logical Structure of the Database
Distinguishing the Different Types of Temporary Segments
Creating Tablespaces
Changing the Size of Tablespaces
Allocating Space for Temporary Segments
Changing the Status of Tablespaces
Changing the Storage Settings of Tablespaces
Relocating Tablespaces

Storage Structure and Relationships

Describing the Logical Structure of the Database
Listing the Segment Types and Their Uses
Listing the Keywords that Control Block Space Usage
Obtaining Information About Storage Structures from the Data Dictionary
Listing the Criteria for Separating Segments

Managing Rollback Segments

Creating Rollback Segments Using Appropriate Storage Settings
Maintaining Rollback Segments
Planning the Number and Size of Rollback Segments
Obtaining Rollback Segment Information from the Data Dictionary
Troubleshooting Common Rollback Segment Problems

Managing Tables

Creating Tables Using Appropriate Storage Settings
Controlling the Space Used by Tables
Analyzing Tables to Check Integrity and Migration
Retrieving Information About Tables from the Data Dictionary
Converting Between Different Formats of ROWID

Managing Indexes

Listing the Different Types of Indexes and Their Uses
Creating B*-Tree and Bitmap Indexes
Reorganizing Indexes
Dropping Indexes
Getting Index Information from the Data Dictionary

Maintaining Data Integrity

Implementing Data Integrity
Maintaining Integrity Constraints
Obtaining Constraint Information from the Data Dictionary

Loading Data

Loading Data Using Direct-Load Insert
Loading Data into Oracle Tables Using SQL*Loader
Conventional
Direct Paths

Reorganizing Data

Reorganizing Data Using Export and Import
Moving Data Using Transportable Tablespaces

Managing Password Security and Resources

Managing Passwords Using Profiles
Administering Profiles
Controlling Use of Resources Using Profiles
Obtaining Information About Profiles, Password Management, and Resources

Managing Users

Creating New Database Users
Altering and Dropping Existing Database Users
Monitoring Information About Existing Users

Managing Privileges

Identifying System and Object Privileges
Granting and Revoking Privileges
Controlling Operating System or Password File Authentication
Identifying Auditing Capabilities

Managing Roles

Creating and Modifying Roles
Controlling Availability of Roles
Removing Roles
Using Predefined Roles
Displaying Role Information from the Data Dictionary

Using National Language Support

Choosing Character Set and National Language Character Set for a Database
Specifying the Language-Dependent Behavior Using Initialization Parameters, Environment Variables, and the ALTER SESSION Command
Using Different Types of NLS Parameters
Obtaining Information About NLS Usage

Next Page: Backup and Recovery (1Z0-025)