Oracle Architectural Components
Physical Structure
Memory Structure
Process Structure
Logical Structure
Stages of an SQL Statement
Oracle Database, the Oracle Server and the Oracle Instance
Getting Started with the Oracle Server
Database Administrative Tools
Features of the Universal Installer
Managing an Oracle Instance
Creating, Managing and Using Initialization Files: PFILE and SPFILE
Various States of Starting an Instance
Various Options Available to Shutdown an Instance
Monitoring Alert and Trace Files
Creating a Database
Using the Database Configuration Assistant
Creating a Database Manually
Using the Data Dictionary
Uses and Contents of the Data Dictionary
Using the Data Dictionary to Obtain Information about the Database
Maintaining the Control File
Uses of the Control File
Contents of the Control File
Maintaining Redo Log Files
Online Redo Log Files
Structure of Online Redo Log Files
Managing Tablespaces and Data Files
Outlining the Database Storage Hierarchy
Types of Tablespaces
Storage Structure and Relationships
Various Segment Types and Their Uses
Storage Clause Precedence
Managing Undo Data
Purpose of Undo Data
Managing Undo Data
Managing Tables
Outlining Various Oracle Data Types
The Two Types of ROWID Formats
Managing Indexes
Classification of Types and Uses Indexes
Creating B-Tree and Bitmap Indexes
Managing Data Integrity
Various Types and States of Constraints
Data Integrity Constraints
Managing Password Security and Resources
Managing Passwords Using Profiles
Administering Profiles
Managing Users
Database Schema and Objects
Creating New Database Users
Managing Privileges and Roles
System and Object Privileges
Using Globalisation Support
Character Set and National Character Set for a Database
Language-Dependent Behaviour
| |
