Skip to main content

 spacer
Professional certification
spacer
  >  		spacer
Certifications
spacer
  >  		spacer
Test information
spacer

Test 910: Managing and Optimizing Informix Dynamic Server Databases


spacer
spacer
spacer Overview spacerObjectives spacer Test Preparationspacer
spacer
spacer

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

spacer
Test registration

Authorized Prometric test centers (worldwide testing)