Test 000-555: IBM Informix Dynamic Server 11.50 Fundamentals

The following list provides information about the exam objectives.

Planning and Installation (15%)

1. Identify data access restrictions
   1. Uers ID controls
   2. Role separation
   3. Single user mode
   4. Admin user mode
   5. GLS libraries
2. Describe database workloads
   1. OLTP vs DSS
3. Describe data type concepts for database planning
   1. UDRs
   2. UDTs
   3. Built-in types
   4. Conceptual knowledge of data blades
4. Demonstrate knowledge of IDS installation and configuration
   1. IDS configuration settings
   2. Installation methods and procedures

Security (5%)

1. Demonstrate knowledge of authentication
   1. LDAP
   2. Simple password
   3. OS users
   4. Single sign-on
2. Demonstrate knowledge of authorizations
   1. Grant/Revoke
   2. Roles
   3. LBAC concepts
3. Demonstrate knowledge of encryption concepts
   1. SSLs
   2. Passwords
   3. ENCCSM
   4. CSM
   5. Encrypted replication

DBMS Instances and Storage Objects (15%)

1. Describe how to identify and connect to IDS servers and databases
   1. ODBC connnection settings
   2. JDBC connnection settings
2. Demonstrate knowledge of storage object creation and configuration
   1. Chunks
   2. dbspaces
   3. table space
   4. Large object spaces
   5. Command line and/or OAT
3. Demonstrate general knowledge of system databases and database catalogs
   1. Identify different types of databases
   2. DDL SQL statements to create objects

IDS Tables, Views and Indexes (10%)

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

IDS Data using SQL (15%)

1. Describe how to use SQL to select data from tables
   1. Use SQL to SORT or GROUP data
2. Describe how to use SQL to update, delete, or insert data
3. Demonstrate knowledge of transactions
   1. commit/rollback and transaction boundaries (exclude save points)
4. Describe how to call a procedure or invoke a user defined function

Data Concurrency (10%)

1. Identify isolation levels and their effects
2. Identify objects on which locks can be obtained
   1. Page vs row level locking

Tools and Utilities (15%)

1. Describe onstat, oninit, and onmode utilities
2. Demonstrate knowledge of data movement utilities
   1. Exclude HPL
3. Describe sysadmin database and its functionality
4. Demonstrate knowledge of the features/functions available in IDS tools
   1. Open Admin (OAT)
   2. DBAccess

Backup and Restore (10%)

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

Replication Technologies (5%)

1. Describe the purpose of different replication technologies
   1. RSS
   2. HDR
   3. Shared disk secondary
   4. Enterprise replication