IBM Informix 11.70 Fundamentals C2090-558 Certified Exam Dumps

C2090-558 Exam Dumps

IBM Informix 11.70 Fundamentals C2090-558 real exam questions and online practice test engine by FreeCram. Try C2090-558 exam questions for free. You can also download a free demo of the C2090-558 exam PDF version.

IBM's C2090-558 actual exam materials brought to you by FreeCram group of IBM certification experts.
View all C2090-558 actual exam questions & answers and explanations for free.

If you like our product, you can request full access to all the latest IBM Informix 11.70 Fundamentals C2090-558 exam premium questions.

Certification Provider: IBM
Exam Code / Number: C2090-558
Exam Name: Informix 11.70 Fundamentals
Exam Questions: 120
Last Updated: Jun 23, 2026
Corresponding Certification: IBM Specialist

Get C2090-558 Premium File

(287 Up Votes)

IBM C2090-558 Exam Syllabus Topics:

TopicDetailsWeights
Informix Tables, Views and Indexes

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

15%
Backup and Restore-Demonstrate knowledge of backup procedures
-Demonstrate knowledge of recovery procedures
8%
Informix Data using SQL

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

14%
Planning and Installation-Identify data access restrictions
-Describe database workloads
-Describe data type concepts for database planning
-Demonstrate knowledge of how to configure and install Informix
-Demonstrate knowledge of embeddability considerations and the deployment utility
16%
Tools and Utilities-Describe onstat, oninit, and onmode utilities
-Demonstrate knowledge of data movement utilities
-Describe sysadmin database and its functionality
-Demonstrate knowledge of the features or functions available in Informix tools
15%
Data Concurrency and Integrity-Identify isolation levels and their effects
-Identify objects on which locks can be obtained
-Describe transaction integrity mechanisms
10%
Security-Demonstrate knowledge of authentication
-Demonstrate knowledge of authorizations
3%
Replication Technologies-Describe the purpose of the different replication technologies5%
DBMS Instances and Storage Objects-Describe how to identify and connect to Informix servers and databases
-Demonstrate knowledge of how to create and configure storage objects
-Demonstrate general knowledge of the system databases and database catalogs
14%

IBM Informix Fundamentals Exam Certification Details:

Number of Questions60
Sample QuestionsIBM Informix Fundamentals Sample Questions
Duration90 mins
Exam CodeC2090-558
Exam Price$200 (USD)
Schedule ExamPearson VUE
Passing Score63%
Exam NameIBM Certified Database Associate - Informix 11.70 Fundamentals


0
0
0
10