Introduction to IBM Certified Database Associate - Informix 11.70 Fundamentals Exam

The IBM C2090-558 Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the Informix Fundamentals certification exam. It contains a detailed list of the topics covered on the Professional exam, as well as a detailed list of preparation resources. These study guides for the IBM Informix 11.70 Fundamentals will help guide you through the study process for your certification.

C2090-558 IBM Informix 11.70 Fundamentals Exam Summary

●     Exam Name: IBM Informix 11.70 Fundamentals

●     Exam Code: C2090-558

●     Exam Price: $200 (USD)

●     Duration: 90 mins

●     Number of Questions: 60

●     Passing Score: 63%

●     Schedule Exam: Pearson VUE

●     Sample Questions: IBM Informix Fundamentals Sample Questions

●     Recommended Practice: IBM C2090-558 Certification Practice Exam

Exam Syllabus: C2090-558 IBM Certified Database Associate - Informix 11.70 Fundamentals

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

 

2. Security (3%)

- Demonstrate knowledge of authentication

- Demonstrate knowledge of authorizations

 

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

 

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

 

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

 

6. Data Concurrency and Integrity (10%)

- Identify isolation levels and their effects

- Identify objects on which locks can be obtained

- Describe transaction integrity mechanisms

 

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

 

8. Backup and Restore (8%)

- Demonstrate knowledge of backup procedures

- Demonstrate knowledge of recovery procedures

 

9. Replication Technologies (5%)

- Describe the purpose of the different replication technologies

IBM C2090-558 Certification Sample Questions and Answers

To make you familiar with IBM Informix 11.70 Fundamentals (C2090-558) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for Informix Fundamentals C2090-558 Certification to test your understanding of IBM C2090-558process with real IBM certification exam environment.

 

C2090-558 IBM Informix 11.70 Fundamentals Sample Questions:-

 

01. Which of the following is true about system catalog tables access?

a) Only user informix can read system catalog tables

b) Only system administrators can read system catalog tables

c) Only database administrators can read system catalog tables

d) Any user that can connect to the database can read system catalog tables

 

02. Which command can be executed against a view?

a) DEFRAGMENT

b) CREATE INDEX

c) CREATE SYNONYM

d) UPDATE STATISTICS

 

03. Which command option should be used to resume an interrupted onbar restore?

a) -RETRY

b) -RESTART

c) -REINTIIALZE

d) -BEGIN_AGAIN

 

04. Which of the following is true about the remote query SELECT * FROM ABC@LMN:XYZ?

a) SELECT from table ABC at database LMN on server XYZ

b) SELECT from table ABC at server LMN on database XYZ

c) SELECT from table LMN on database ABC on server XYZ

d) SELECT from table XYZ on database ABC at server LMN

 

05. Which of the following methods will allow you to determine how much space is currently in use?

a) Query the $ table

b) Query the sysstats database

c) Query the sysusers database

d) Query the sysmaster database

 

06. When installing Informix, which two installation methods can be used?

(Choose two.)

a) quiet

b) native

c) staged

d) console

e) graphical

 

07. Which document provides details on preparing an operating system to run Informix?

a) Machine Notes

b) System User's Guide

c) Operating System Guide

d) Informix Migration Guide

 

08. Which two statements will delete all rows from table_name?

(Choose two.)

a) DROP FROM table_name ;

b) DELETE FROM table_name ;

c) DELETE * FROM table_name ;

d) TRUNCATE TABLE table_name ;

e) DELETE ALL FROM table_name ;

 

09. Why would you want to create a table with a lock mode row as opposed to a lock mode page?

a) to reduce disk I/O

b) to increase concurrency among multiple users on the same table

c) to keep more information in memory for each locked row

d) to reduce the number of locks when accessing rows out of the table

 

10. In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?

a) sysutils

b) sysusers

c) sysadmin

d) sysmaster

 

Answers:-

Answer 1:- d

Answer 2:- c

Answer 3:- b

Answer 4:- d

Answer 5:- d

Answer 6:- d, e

Answer 7:- a

Answer 8:- b, d

Answer 9:- b

Answer 10:- c