000-910 V5.28
Posted by | Posted in education | Posted on 31-05-2011
Cost: $0
Size: 159.36 kB
Release date: 30 Mar 2011
Platform: Windows2000,WinXP,Windows2003,Linux,Java
Download: 000-910 Freeware
* IBM Certified Solutions Expert — Informix Dynamic Server V7 System Administrator
* IBM Certified Solutions Expert — Informix Dynamic Server V9 System Administrator
Section 1 – Informix Dynamic Server Terminology (6%)
Section 2 – Managing Databases and Tables (8%)
1. Demonstrate an understanding of the system catalog
Section 3 – Fragmentation (12%)
Section 4 – Concurrency Control (13%)
1. Demonstrate an understanding of concurrency control
2. Manage isolation and locking levels
Section 5 – Indexing Strategy (14%)
1. Demonstrate an understanding of how indexes are built and maintained
2. Demonstrate an understanding of the index types
3. Write statements to create and manage indexes
4. Manage temporary files
Section 6 – Referential and Entity Integrity (8%)
1. Demonstrate an understanding of of data integrity constraints and constraint transaction modes
Section 7 – Modes and Violation Detection (7%)
1. Demonstrate an understanding of database objects and modes
2. Write statements to enable and siable objects
3. Demonstrate an understanding of the violations and diagnostics tables
Section 8 – Cost-Based Optimizer (11%)
1. Demonstrate an understanding of the optimization process
2. Manage the cost-based optimizer
Section 9 – Update Statistics (8%)
1. Demonstrate an understanding of UPDATE STATISTICS
2. Demonstrate an understanding of data distributions
Section 10 – Data Security (4%)
1. Manage data security through user privileges at the database, table and column level
Section 11 – Views (4%)
1. Demonstrate an understanding of of views
2. Write statements to manage views
Section 12 – Data Movement Utilities (5%)
Note: This test will be withdrawn on Mar 31 2011.
More informations view: http://www.test4pass.com/000-910-exam.html easier way to success!




