Skip to main content

 
Professional certification

  >  
Certifications

  >  
Test information

Test 910: Managing and Optimizing Informix Dynamic Server Databases


Overview Objectives alt="" height="1" width="30" Test Preparation

If you are knowledgeable with Informix Dynamic Server Version 7 and are capable of performing the intermediate to advanced skills required in the day-to-day administration of Informix databases, you may benefit from this certification role. 

Section 1 - Informix Dynamic Server Terminology (6%)


Demonstrates an understanding of Informix Dynamic Server disk components

Section 2 - Managing Databases and Tables (8%)


Demonstrate an understanding of the system catalog
Demonstrate an understanding of table lock modes
Create and manage databases, tables and indexes

Section 3 - Fragmentation (12%)


Demonstrate an understanding of fragmentation including goals and advantages of fragmentation
Demonstrate an understanding of distribution schemes and parallel scans
Write statements to manage fragments

Section 4 - Concurrency Control (13%)


Demonstrate an understanding of concurrency control
Manage isolation and locking levels

Section 5 - Indexing Strategy (14%)


Demonstrate an understanding of how indexes are built and maintained
Demonstrate an understanding of the index types
Write statements to create and manage indexes
Manage temporary files

Section 6 - Referential and Entity Integrity (8%)


Demonstrate an understanding of of data integrity constraints and constraint transaction modes

Section 7 - Modes and Violation Detection (7%)


Demonstrate an understanding of database objects and modes
Write statements to enable and siable objects
Demonstrate an understanding of the violations and diagnostics tables

Section 8 - Cost-Based Optimizer (11%)


Demonstrate an understanding of the optimization process
Manage the cost-based optimizer

Section 9 - Update Statistics (8%)


Demonstrate an understanding of UPDATE STATISTICS
Demonstrate an understanding of data distributions

Section 10 - Data Security (4%)


Manage data security through user privileges at the database, table and column level

Section 11 - Views (4%)


Demonstrate an understanding of of views
Write statements to manage views

Section 12 - Data Movement Utilities (5%)


Demonstrate an understanding of the following utilities: dbimport, dbexport, dbload, onload and onunload

Test registration

Authorized Prometric test centers (worldwide testing)