Oracle9i Database: Fundamentals I™

Exam Topics

Oracle Architectural Components
[  ] Describe the Oracle architecture and its main components
[  ] Describe the structures involved in connecting a user to an Oracle instance

Getting Started With the Oracle Server
[  ] Identify common database administrative tools available to a DBA
[  ] Identify the features of the Oracle Universal Installer
[  ] Explain the benefits of Optimal Flexible Architecture
[  ] Set up password file authentication
[  ] List the main components of the Oracle Enterprise Manager and their uses

 

Maintaining the Control File
[  ] Explain the uses of the control file
[  ] Describe the contents of the control file
[  ] Multiplex and manage the control file
[  ] Manage the control file with Oracle Managed Files
[  ] Obtain control file information

Managing Tablespaces and Data files
[  ] Describe the logical structure of tablespaces within the database
[  ] Create tablespaces
[  ] Change the size of the tablespace
[  ] Allocate space for temporary segments
[  ] Change the status of tablespaces
[  ] Change the storage settings of tablespaces
[  ] Implement Oracle Managed Files

Managing Tables
[  ] Identify the various methods of storing data
[  ] Describe Oracle data types
[  ] Distinguish between an extended versus a restricted ROWID
[  ] Describe the structure of a row
[  ] Create regular and temporary tables
[  ] Manage storage structures within a table
[  ] Reorganize, truncate, drop a table
[  ] Drop a column within a table

Managing an Oracle Instance
[  ] Create and manage initialization parameter files
[  ] Configure OMF
[  ] Start up and shut down an instance
[  ] Monitor the use of diagnostic files

Creating a Database
[  ] Describe the prerequisites necessary for database creation
[  ] Create a database using Oracle Database Configuration Assistant
[  ] Create a database manually

Maintaining Redo Log Files
[  ] Explain the purpose of online redo log files
[  ] Describe the structure of online redo log files
[  ] Control log switches and checkpoints
[  ] Multiplex and maintain online redo log files
[  ] Manage online redo log files with OMF

Storage Structure and Relationships
[  ] Describe the logical structure of segments within the database
[  ] Describe the segment types and their uses
[  ] List the keywords that control block space usage
[  ] Obtain information about storage structures from the data dictionary

Managing Undo Data
[  ] Describe the purpose of undo data
[  ] Implement Automatic Undo Management

Managing Indexes
[  ] Describe the different types of indexes and their uses
[  ] Create various types of indexes
[  ] Reorganize indexes
[  ] Drop indexes
[  ] Get index information from the data dictionary
[  ] Monitor the usage of an index

Data Dictionary Content and Usage
[  ] Identify key data dictionary components
[  ] Identify the contents and uses of the data dictionary
[  ] Query the data dictionary

Managing Password Security and Resources
[  ] Manage passwords using profiles
[  ] Administer profiles
[  ] Control use of resources using profiles
[  ] Obtain information about profiles, password management and resources

Managing Users
[  ] Create new database users
[  ] Alter and drop existing database users
[  ] Monitor information about existing users

Managing Privileges
[  ] Identify system and object privileges
[  ] Grant and revoke privileges
[  ] Identify auditing capabilities

Managing Roles
[  ] Create and modify roles
[  ] Control availability of roles
[  ] Remove roles
[  ] Use predefined roles
[  ] Display role information from the data dictionary
Maintaining Data Integrity
[  ] Implement data integrity constraints
[  ] Maintain integrity constraints
[  ] Obtain constraint information from the data dictionary

Using Globalization Support
[  ] Choose database character set and national character set for a database
[  ] Specify the language- dependent behavior using initialization parameters, environment variables and the ALTER SESSION command
[  ] Use the different types of National Language Support (NLS) parameters
[  ] Explain the influence on language-dependent application behavior
[  ] Obtain information about Globalization Support usage

About eagle081183

Passionate, Loyal
This entry was posted in Database, Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s