IBM 000-558 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | Informix 11.70 Fundamentals |
| Exam Number: | 000-558 / C2090-558 |
| Available Languages: | English |
| Exam Format: | Multiple choice |
| Exam Price: | USD 200 |
| Certificate Validity Period: | 3 years |
| Exam Duration: | 90 minutes |
| Passing Score: | 63% (38 out of 60) |
| Real Exam Qty: | 60 |
| Recommended Training: | IBM Informix 11.70 Fundamentals Training |
| Exam Registration: | IBM Certification Portal Pearson VUE Registration |
| Sample Questions: | IBM 000-558 Sample Questions |
| Exam Way: | Proctored onsite at Pearson VUE / Prometric centers; online proctoring available where supported |
| Pre Condition: | No required prerequisites; basic database knowledge recommended |
| Official Syllabus URL: | https://www.ibm.com/training/certification/ibm-certified-database-associate-informix-11-70-fundamentals |
IBM 000-558 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Replication Technologies | 5% | - High-availability data replication - Purpose and usage scenarios |
| Topic 2: Security and Privileges | 14% | - User accounts and authentication - Access control and permissions - Authorization and roles |
| Topic 3: Data Concurrency and Integrity | 10% | - Isolation levels - Locking mechanisms - Transaction integrity |
| Topic 4: Informix Architecture and Concepts | 14% | - System architecture and components - Configuration parameters - Database and instance structure |
| Topic 5: Tools and Utilities | 15% | - Sysadmin database - Data movement utilities - onstat, oninit, onmode commands |
| Topic 6: Informix Tables, Views and Indexes | 15% | - Creating and modifying tables - Indexes, views, sequences, synonyms, triggers - Constraints, referential integrity |
| Topic 7: DBMS Instances and Storage Objects | 14% | - Dbspaces, chunks, and extents - Storage management - Logical and physical logs |
| Topic 8: Backup and Restore | 8% | - Recovery procedures - Backup strategies - Point-in-time recovery |
| Topic 9: Data Access Using SQL | 14% | - SELECT, INSERT, UPDATE, DELETE statements - Transactions and isolation - Stored procedures and functions |

We're so confident of our products that we provide no hassle product exchange.


By Jay


