Test information:
Number of questions: 60
Time allowed in minutes: 90
Required passing score: 62%
Languages: English

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

IBM Certified Database Associate – Informix 11.70 Fundamentals

Job Role Description / Target Audience
The successful candidate for the IBM Certified Database Associate – Informix 11.70 Fundamentals has important knowledge, skills, and abilities necessary to provide entry level administration of Informix, including basic SQL (Structured Query Language), how Informix is installed, how to create databases and database objects, security, transaction isolation, backup and recovery procedures, and describe replication technologies and purposes.

This certification targets:
Entry level technical professionals – programming, system design, architect
University students – application of information technology
Entry level DBAs – database administration

Recommended Prerequisite Skills

The following subjects are covered within this examination:
Planning and Installation
Security
DBMS Instances and Storage Objects
Informix Tables, Views, and Indexes
Informix Data using SQL
Data Concurrency and Integrity
Tools and Utilities
Backup and Restore
Replication Technologies


QUESTION: 1
When restoring data, which granularity of object may NOT be restored?

A. a single table
B. a single chunk
C. a single dbspace
D. an entire instance

Answer: B


QUESTION: 2
Which command would you execute to restore to a specific moment-in—time?

A. onbar—t timestamp
B. onbar—r —|og Iognum
C. onbar —r —t timestamp
D. onbar —r -| timestamp

Answer: C


QUESTION: 3
Click the Exhibit button.

An administrator created a table using the SQL statement shown in the exhibit to perform a load operation every day
at 11:00 Al\/I. What is the best way to optimize a backup strategy to recover the client table in case of a failure?

A. a |eveI—1 backup at 6:00 Al\/I everyday
B. a |eveI—0 backup soon after the load operation
C. a |eveI—1 backup on Sunday and continuous log backup
D. a |eveI—2 backup at 6:00 Al\/I every day and continuous log backup

Answer: B


QUESTION: 4
Which command option should be used to resume an interrupted onbar restore?

A. -RETRY
B. -RESTART
C. -RElNTllALZE
D. -BEGlN_AGAlN

Answer: B

Click here to view complete Q&A of C2090-558 exam
Certkingdom Review

MCTS Training, MCITP Trainnig

Best IBM C2090-558 Certification, IBM C2090-558 Training at certkingdom.com