Test 000-558: Informix 11.70 Fundamentals

The test contains six sections totalling approximately 60 multiple-choice questions.  The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 - Planning and Installation (16%)

1. Identify data access restrictions
2. Describe database workloads
3. Describe data type concepts for database planning
4. Demonstrate knowledge of how to configure and install Informix
5. Demonstrate knowledge of embeddability considerations and the deployment utility

Section 2 - Security (3%)

1. Demonstrate knowledge of authentication
2. Demonstrate knowledge of authorizations

Section 3 - DBMS Instances and Storage Objects (14%)

1. Describe how to identify and connect to Informix servers and databases
2. Demonstrate knowledge of how to create and configure storage objects
3. Demonstrate general knowledge of the system databases and database catalogs

Section 4 - Informix Tables, Views and Indexes (15%)

1. Given a scenario, describe how to create a table
2. Describe when referential integrity should be used
3. Describe methods of data value constraint
4. Describe the differences between a table, view, sequences, synonyms, and indices
5. Describe triggers and appropriate uses
6. Demonstrate knowledge of schema commands

Section 5 - Informix Data using SQL (14%)

1. Describe how to use SQL to SELECT data from tables
2. Describe how to use SQL to UPDATE, DELETE, or INSERT data
3. Demonstrate knowledge of transactions
4. Describe how to call a procedure or invoke a user defined function

Section 6 - Data Concurrency and Integrity (10%)

1. Identify isolation levels and their effects
2. Identify objects on which locks can be obtained
3. Describe transaction integrity mechanisms

Section 7 - Tools and Utilities (15%)

1. Describe onstat, oninit, and onmode utilities
2. Demonstrate knowledge of data movement utilities
3. Describe sysadmin database and its functionality
4. Demonstrate knowledge of the features or functions available in Informix tools

Section 8 - Backup and Restore (8%)

1. Demonstrate knowledge of backup procedures
2. Demonstrate knowledge of recovery procedures

Section 9 - Replication Technologies (5%)

1. Describe the purpose of the different replication technologies