The IBM C2090-913 Exam is challenging and thorough preparation is essential for success. This exam study guide is designed to help you prepare for the Informix 4GL Development 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 4GL Development will help guide you through the study process for your certification.
C2090-913 IBM Informix 4GL Development Exam Summary
● Exam Name: IBM Informix 4GL Development
● Exam Code: C2090-913
● Exam Price: $200 (USD)
● Duration: 90 mins
● Number of Questions: 90
● Passing Score: 70 / 90
● Books / Training: Online Course
● Schedule Exam: Pearson VUE
● Sample Questions: IBM Informix 4GL Development Sample Questions
● Recommended Practice: IBM C2090-913 Certification Practice Exam
Exam Syllabus: C2090-913 IBM Certified Solutions Expert - Informix 4GL Developer
1. Informix 4GL (18%)
2. Statements (28%)
3. Cursors and Memory (13%)
4. Creating a Help File: The mkmessage Utility (1%)
5. Creating a Report Driver (3%)
6. Defining Program Variables (3%)
7. Displaying Forms and Windows (4%)
8. Forms that use Arrays (4%)
9. Passing Values between Functions (6%)
10. procedural Logic (1%)
11. The REPORT Functions (3%)
12. The SQLCA Record (6%)
IBM C2090-913 Certification Sample Questions and Answers
To make you familiar with IBM Informix 4GL Development (C2090-913) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for Informix 4GL Development C2090-913 Certification to test your understanding of IBM C2090-913process with real IBM certification exam environment.
C2090-913 IBM Informix 4GL Development Sample Questions:-
01. Which statement is true about the following?
I_cust_num INT
a) LET I_cust_num.* = NULL
b) LET I_cust_num = NULL
c) INITIALIZE I_cust_num = NULL
d) INITIALIZE I_cust_num.* = NULL
e) INITIALIZE I_cust_num.* TO NULL
02. What is a valid control block in the FORMAT section of a report?
a) REPORT TO "<filename>"
b) ON EVERY ROW, ORDER BY
c) REPORT TO, ORDER BY, ON EVERY ROW
d) ON LAST ROW, FIRST PAGE HEADER, AFTER GROUP OF
e) LEFT MARGIN, ON EVERY ROW, REPORT TO "<filename>"
03. What are two methods of getting user-entered parameters to a 4GL report?
(Choose two.)
a) by using a DISPLAY statement
b) by using a PROMPT statement
c) by using a screen form and an INPUT statement
d) by setting up a user profile library within the TK libraries
04. How can you programmatically determine the SERIAL value assigned after inserting a row?
a) use the get_diagnostics() function
b) define a 4GL variable of type SERIAL
c) check the value in the SQLCA structure
d) track the SERIAL value in a program variable
05. The end user is requesting a one-time update to correct the shipping charges on some customer orders. The changes go into effect for orders placed on or after January 1, 1999. Any orders placed after this date should have the shipping charge increased by 10 cents. Which statement makes the correction?
a) FOREACH c_curs INTO l_ord_num, l_shp_chg LET l_shp_chg = l_shp_chg + .10
b) UPDATE orders SET ship_charge = (ship_charge + .10) WHERE order_date >= "01/01/1999"
c) UPDATE orders SET ship_charge = l_shp_chg WHERE order_num = l_ord_num END FOREACH
d) DECLARE c_curs CURSOR FOR SELECT order_num, ship_charge FROM orders WHERE order_date= "01/01/1999"
06. Which cursor type can use the FETCH PREVIOUS syntax?
a) scroll cursor
b) update cursor
c) non-scrolling cursor
d) a mobile cursor available only in D4GL
07. What defines SQLCA.SQLERRD[2]?
a) ROWID of the last row
b) number of rows processed
c) status of an SQL statement
d) serial value assigned to a column
08. What is the standard size of the 4GL screen?
a) 24 rows x 80 columns
b) 80 rows x 24 columns
c) 50 columns x 132 rows
d) 132 columns x 50 rows
09. Which statement defines the control statement "WHILE"?
a) It executes a set of statements a specific number of times.
b) It determines whether an expression evaluates to true or false.
c) It determines a course of action when an expression evaluates to true.
d) It repeatedly executes a set of actions until the boolean condition evaluates to false.
10. From the following five choices of development standards listed below, only four are necessary to have in place at a client site before development begins. Choose the one choice that is not necessary.
a) templates for forms
b) templates for report.
c) templates for screen i/o functions
d) naming conventions for variables, functions, and source modules
e) naming conventions for source i/o communications from the application to the server.
Answers:-
Answer 1:- b
Answer 2:- e
Answer 3:- b, c
Answer 4:- c
Answer 5:- b
Answer 6:- a
Answer 7:- d
Answer 8:- a
Answer 9:- d
Answer 10:- e
Comments