Maintaining Data Integrity
Identifying the various types and states of constraints
Implementing data integrity constraints

Managing Password Security and Resources
Managing passwords using profiles
Administering profiles

Managing Users
Defining database schema and objects
Creating new database users

Managing Privileges and Roles
Identifying system and object privileges
Granting and revoking privileges

Using Globalization Support
Choosing character set and national character set for a database
Specifying the language-dependent behavior

Section 2 - Oracle9i Database Administration Fundamentals II
Time Allocated - 24 hours

Section Objectives:
List the Oracle architecture components related to backup and recovery operations
Develop network configuration and recovery techniques through various workshop scenarios
Describe the database utilities (SQL*Loader, Export, and Import) and the situations where they can be used
Define networking requirements and the solutions provided by Oracle to implement these requirements
List the different Oracle backup methods and recovery operations that can be used to resolve database failure
Configure the network environment for an Oracle client-server system
Perform database and datafile backups with and without Recovery Manager (RMAN)

Previous page << pg1 pg2 pg3 PAGE 4 pg5 pg6 pg7 pg8 pg9 pg10 pg11 pg12 pg13 Next page >>