C2090-558 Exam Information and Guideline
Informix 11.70 Fundamentals
Below are complete topics detail with latest syllabus and course outline, that will help you good knowledge about exam objectives and topics that you have to prepare. These contents are covered in questions and answers pool of exam.
Exam Code : C2090-558
Exam Name : Informix 11.70 Fundamentals
Number of questions: 60
Number of questions to pass: 38
Time allowed: 90 mins
Status: Live
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%
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
Section 2 - Security 3%
Demonstrate knowledge of authentication
Demonstrate knowledge of authorizations
Section 3 - DBMS Instances and Storage Objects 14%
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
Section 4 - Informix Tables, Views and Indexes 15%
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
Section 5 - Informix Data using SQL 14%
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
Section 6 - Data Concurrency and Integrity 10%
Identify isolation levels and their effects
Identify objects on which locks can be obtained
Describe transaction integrity mechanisms
Section 7 - Tools and Utilities 15%
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
Section 8 - Backup and Restore 8%
Demonstrate knowledge of backup procedures
Demonstrate knowledge of recovery procedures
Section 9 - Replication Technologies 5%
Describe the purpose of the different replication technologies