|
Oracle9i Database: Fundamentals
I
Exam Number: 1Z0-031
Associated Certifications: Oracle9i DBA OCA
Exam Price: $125.00 USD
Duration: 120 minutes
Passing Score: 73%
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
|
