IBM


IBM Professional Certification Program

Accelerate insight. Improve skills. Get certified now.

Test C2090-558: Informix 11.70 Fundamentals


cert assess save

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



Promotions


Connect with Us