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
Best IBM C2090-558 Certification, IBM C2090-558 Training at certkingdom.com