Oracle9i Database: Fundamentals I™

Exam Number:	1Z0-031
Associated Certifications:	Oracle9i DBA OCA
Exam Price:	US$125
Exam Registration:	Register

Duration:

120 minutes

Number of Questions:

Passing Score:

73%

Passing score subject to change. View Details

Recommended Training and Preparation

The exam is based on Oracle9i Release 2

Oracle9i Database: Fundamentals I

Oracle9i DBA Fundamentals I Self-Study CD Course (NETg Oracle)
Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only.

Additional Information & Resources

Practice Exams

Oracle authorized practice exam from Self Test Software. 1Z0-031 Oracle9i: DBA Fundamentals I
Oracle authorized practice exam from Transcender: Cert-1Z0-031 : DBCert: 9i Database: Fundamentals I

Oracle9i DBA Certification Exam Candidate Guide
Exam Retake Policy
Sample Questions

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

Oracle Certification Program Fraudulent Activity Policy

Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.