Informix 4GL Development v6.0 (C2090-913)

Page:    1 / 10   
Total 149 questions

Which OPEN FORM statements are syntactically correct?

  • A. OPEN FORM formname FROM "formfile"
  • B. OPEN FORM formname FROM formvariable
  • C. OPEN FORM "formname" FROM formfile.frm
  • D. OPEN FORM formname IN WINDOW winname WITH FORM "formfile"
  • E. OPEN FORM formname FROM "formfile.frm"


Answer : A,B

SQL statements being prepared in conjunction with a CONSTRUCT statement should beprepared

  • A. just before the SQL statement is to be executed or opened
  • B. in an initialization function at the top of each 4GL module
  • C. at the top of each function containing the EXECUTE or OPEN statement
  • D. in an initialization function in the module containing the MAIN function


Answer : A

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

  • A. by INFORMIX-4GL after 1 second has elapsed
  • B. by executing the DEFER INTERRUPT statement
  • C. only if the application code resets it to FALSE
  • D. by INFORMIX-4GL after the IF int_flag statement is executed


Answer : C

Which cursor type always places a lock on the current row fetched?

  • A. scroll cursor
  • B. update cursor
  • C. non-scrolling cursor


Answer : B

Which cursor is most effective when retrieving data for a user that wants areport to generate a customer listing sorted by city and last name?

  • A. update cursor
  • B. scroll cursor
  • C. non-scrolling cursor


Answer : C

Which are components of the SQLCA record?

  • A. STATUS
  • B. SQLERRD
  • C. SQLODBC
  • D. SQLCODE
  • E. SQLAWARN


Answer : B,D,E

Which parameters can be passed to a function?

  • A. constants
  • B. concatenators
  • C. date variables
  • D. array variables
  • E. integer variables


Answer : A,C,E

Click the Exhibit button to view the exhibit. Given the code in the exhibit, whichstatement iscorrect?

  • A. The WHENEVER ERROR CONTINUE is active while in function A.
  • B. The WHENEVER ERROR CONTINUE is active when function B is called.
  • C. The WHENEVER ERROR STOP is active for MAIN, function A and function B.
  • D. The WHENEVER ERROR STOP is active throughout as it was declared in the MAIN function.


Answer : C

What is a disadvantage of using a SCROLL cursor?

  • A. GROUP BY clauses are not allowed.
  • B. Temporary tables are always created and could be quite large.
  • C. Rows fetched must be retrieved from the database table each time.
  • D. Temporary tables may have to be created and could be quite large.


Answer : B

Which ATTRIBUTE clauses are valid?

  • A. ERROR "text" ATTRIBUTE (SILENT)
  • B. MESSAGE "text" ATTRIBUTE (REVERSE)
  • C. DISPLAY "text" AT 2, 2 ATTRIBUTE (BORDER)
  • D. PROMPT "text" ATTRIBUTE (REVERSE) FOR CHAR x


Answer : B,D

Click the Exhibit button to view the exhibit. Given the clauses in the exhibit, which clause will beexecuted immediately after the user presses the ACCEPT KEY while in the code field?

  • A. AFTER ROW
  • B. BEFORE ROW
  • C. AFTER INSERT
  • D. AFTER FIELD code


Answer : D

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


Answer : A

Which statement is true about the SERIAL data type?

  • A. A table can have multiple SERIAL columns.
  • B. SERIAL values within a table MUST be unique.
  • C. SERIAL values are stored in the database as integers.
  • D. Once deleted, SERIAL values are automatically reused.


Answer : C

Click the Exhibit button to view the exhibit. After the code in the exhibit is executed, what is thevalue of "total"?

  • A. 1
  • B. 11
  • C. 10
  • D. 100


Answer : B

What is required in a form to implement multiple-line editing features for acharacter field?

  • A. two fields of the same length in the SCREEN section
  • B. an OPTIONS WORD WRAP line in the INSTRUCTIONS section
  • C. a SCREEN RECORD for the field in the INSTRUCTIONS section
  • D. at least two fields in the SCREEN section with the same field tag
  • E. the WORDWRAP attribute included for the field in the ATTRIBUTES section


Answer : D,E

Page:    1 / 10   
Total 149 questions