Informix 4GL Development C2090-913 Practice Exam Questions

Someone is a knowledgeable Informix 4GL Developer and are capable of performing the intermediate to advanced skills required to design and develop Informix database applications, he/she will benefit from IBM Certified Solutions Expert — Informix 4GL Developer certification. Now, just choose great Informix 4GL Development C2090-913 Practice Exam Questions to prepare for C2090-913 exam. Passing IBM C2090-913 exam successfully make you get IBM Certified Solutions Expert — Informix 4GL Developer certification

You can read free C2090-913 exam questions to find the quality of C2090-913 practice exam questions below:

1. Click the <<ItemExhibitName>> button to view the exhibit.

image001

Given the form in the exhibit, which code segment would properly add 10 to the input contents of field a and display the results in field b?

 
 
 
 

2. Which type of errors can be trapped by SQLCA.SQLCODE?

 
 
 
 

3. Which statements will be interrupted if the DEFER INTERRUPT statement has been executed and the user presses the interrupt key?

 
 
 
 
 

4. Click the <<ItemExhibitName>> button to view the exhibit.

image002

Given the segment of code in the exhibit, what is the appropriate text for the variable what_error_message?

 
 
 
 

5. Which are valid INFORMIX-4GL function types?

 
 
 
 
 
 
 

6. Click the <<ItemExhibitName>> button to view the exhibit.

image004

Given the exhibit, which rows will the DELETE statement delete?

 
 
 
 

7. Why will preparing UPDATE and DELETE statements increase their execution speed?

 
 
 
 

8. Click the <<ItemExhibitName>> button to view the exhibit.

image005

image006

image008

image009

image010

Given the exhibit, what is the stock_curs cursor being used to do?

 
 
 
 

9. Which values will the form display when using the INPUT ARRAY statement?

 
 
 
 
 
 
 

10. Click the <<ItemExhibitName>> button to view the exhibit.

image011

Given the code segment in the exhibit, which function(s) would be called?

 
 
 
 

11. Which qualifiers can be used when formatting report output?

 
 
 
 
 
 

12. Which statement is correct about the BEFORE MENU clause of the MENU statement?

 
 
 
 

13. Which sequence of steps opens a form and displays it on the screen?

 
 
 
 

14. What are characteristics of INFORMIX-4GL RDS?

 
 
 
 

15. Which statement about INFORMIX-4GL is true?

 
 
 
 

16. What is one advantage of using INFORMIX-4GL C-compiled version versus INFORMIX-4GL RDS?

 
 
 
 

17. An end user wants to see how values x and y are being set in function1 and function2, and also needs to know the value of z before function3 is called.

image012

Using the Informix 4GL Debugger, which sequence of steps accomplishes this?

 
 
 
 

18. Given the following directory structure, where would you find two existing libraries for the application? (Choose two.)

 
 
 
 

19. The end users at your client site require the ability to enter purchase orders online. Management has agreed to allow the users to perform this function, but with some restrictions. End users will be classified as one of three categories:

image013

Each category of employee will have the following limits on the amount of the purchase order they are allowed to enter:

image014

Given the following table structures and relationship:

image015

Which two functions must be created to determine the maximum purchase order amount that a user is authorized to enter? (Choose two.)

 
 
 
 

20. Which cursor type can use the FETCH PREVIOUS syntax?

 
 
 
 

21. Which statement transfers fields on a form to program variables?

 
 
 
 

22. What does the INPUT statement do?

 
 
 
 

23. Which clauses must be included in an INPUT statement?

 
 
 
 
 
 

24. Which statement uses correct syntax for the INPUT statement?

 
 
 
 

25. Click the <<ItemExhibitName>> button to view the exhibit.

image016

Given the code in the exhibit, what would be displayed in the field lastname if the user were to enter "Jones" and press F3 in the lastname field? (Assume lastname is 20 characters long.)

 
 
 
 

26. Which INPUT statements are syntactically correct?

 
 
 
 
 
 

27. What is the effect of the WITHOUT DEFAULTS clause of an INPUT statement?

 
 
 
 

28. Which are valid clauses of an INPUT statement?

 
 
 
 
 
 
 
 

29. Which statements can be used in an INPUT statement control block?

 
 
 
 
 
 

30. Click the <<ItemExhibitName>> button to view the exhibit.

image017

Given the form in the exhibit, which code segment would properly add 10 days to the input contents of field a and display the results in field b?

 
 
 
 

31. Which code segment will show field-specific help at the user s request during an INPUT statement?

 
 
 
 

32. What is the primary function of the INSERT statement?

 
 
 
 

33. When is the column-list optional in the INSERT statement?

 
 
 
 

34. Which statements are true about the INSERT statement?

 
 
 
 
 
 

35. What must be done prior to using an EXECUTE statement for an INSERT statement?

 
 
 
 

36. What is the proper method for inserting a value into a column assigned a data type of SERIAL?

 
 
 
 

37. How can you programmatically determine the SERIAL value assigned after inserting a row?

 
 
 
 

38. Other than when a zero value is supplied for a SERIAL column, when will the database assign a SERIAL value?

 
 
 
 

39. Click the <<ItemExhibitName>> button to view the exhibit.

image018

In the exhibit, assuming all of the program variables have been populated with the appropriate data, which statement should be used to put the values into the employee table?

 
 
 
 

40. Which statement is true about the SERIAL data type?

 
 
 
 

41. What must be true for this statement to execute?

image019

 
 
 
 

42. Given this statement, if the customer table contains a SERIAL column, which statement should be executed prior to the INSERT?

image020

 
 
 
 

43. Which structure contains information about the most recently executed SQL statement?

 
 
 
 

44. Which statements are true about SQLCA?

 
 
 
 

45. Which are components of the SQLCA record?

 
 
 
 
 

46. What does an SQLCA.SQLCODE value of zero indicate after an SQL statement is executed?

 
 
 
 

47. For a non-ANSI database, if an UPDATE statement executes successfully, but modifies no rows in the database, what will SQLCA.SQLCODE be set to?

 
 
 
 

48. When checking the return status of an SQL statement, why is it advisable to use SQLCA.SQLCODE instead of STATUS?

 
 
 
 

49. When checking the return status of 4GL application statements such as PROMPT, why is it advisable to use STATUS instead of SQLCA.SQLCODE?

 
 
 
 

50. When would you want to use both STATUS and SQLCA.SQLCODE?

 
 
 
 

51. If a LET statement is executed, but the assignment doesn’t work at run-time, which variable is set to indicate an error? (Ex: A CHAR string containing an invalid date is assigned to a date variable.)

 
 
 
 

52. At run-time, conditions may occur that produce warnings, but not errors. How can you easily look for these warnings?

 
 
 
 

53. Which errors are 4GL run-time errors?

 
 
 
 

54. Which statements are true about the WHENEVER ERROR statement?

 
 
 
 

55. For a non MODE ANSI database, what is the default behavior for handling a run-time error?

 
 
 
 

56. Click the <<ItemExhibitName>> button to view the exhibit.

image021

Given the exhibit, if error -113 occurred after executing the INSERT statement, which error message would display?

 
 
 

57. Which statements are true about the WHENEVER ERROR statement options?

 
 
 
 

58. Click the <<ItemExhibitName>> button to view the exhibit.

image022

Given the code in the exhibit, which statement is correct?

 
 
 
 

59. Click the <<ItemExhibitName>> button to view the exhibit.

image023

Given the code segment in the exhibit, which WHENEVER statement is active after exiting the IF statement?

 
 
 

60. What does the DEFER INTERRUPT statement trap?

 
 
 
 

61. What is int_flag?

 
 
 
 

62. Which statements can be interrupted once a DEFER INTERRUPT has been set?

 
 
 
 

63. When is int_flag set to TRUE?

 
 
 
 

64. How is the int_flag set to true?

 
 
 
 

65. Click the <<ItemExhibitName>> button to view the exhibit.

image024

Why is the line "LET int_flag = FALSE" and its placement in the code segment important?

 
 
 

66. If DEFER INTERRUPT is set at the beginning of the application, why must your application set int_flag to FALSE before an INPUT statement is executed?

 
 
 
 

67. After a user-interrupt sets the int_flag to TRUE, how can it be reset to FALSE?

 
 
 
 

Effective C2040-402 Administering IBM Connections 4.0 Exam Guide
IBM Big Data Engineer C2090-101 Exam Questions

Add a Comment

Your email address will not be published. Required fields are marked *