- All Exams Instant Download
Assume a developer wants to validate the contents of a program variable against a list of allowed values while executing an INPUT statement. Which validation method requires the least amount of code changes should the list of allowed values change?
Assume a developer wants to validate the contents of a program variable against a list of allowed values while executing an INPUT statement. Which validation method requires the least amount of code changes should the list of allowed values change?A . Referencing the list of allowed values in the INCLUDE...
Which statements implement explicit transactions?
Which statements implement explicit transactions?A . BEGIN WORKB . COMMIT WORKC . ROLLBACK WORKD . END TRANSACTIONE . EXIT TRANSACTIONF . START TRANSACTIONView AnswerAnswer: ABC
Which clauses must be included in an INPUT statement?
Which clauses must be included in an INPUT statement?A . TOB . FROMC . INPUTD . ATTRIBUTEE . screen_variableF . program_variableView AnswerAnswer: CF
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?
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? A. 0 B. 1 C. <0 D. the number of rows in the target tableView AnswerAnswer: A
Which statement uses correct syntax for the INPUT statement?
Which statement uses correct syntax for the INPUT statement?A . INPUT program_variable FROM screen_variableB . INPUT FROM program_variable TO screen_variableC . INPUT TO program_variable FROM screen_variableD . INPUT ATTRIBUTE BY NAME TO program_variable FROM screen_variableView AnswerAnswer: A
What does the INPUT statement do?
What does the INPUT statement do?A . It defines variables used in a form.B . It moves a user through the fields in a form.C . It automatically opens the form and displays it.D . It assigns a field in a form to a program variable.View AnswerAnswer: BD
When is int_flag set to TRUE?
When is int_flag set to TRUE?A . when the DEFER INTERRUPT statement is executedB . only at program initialization by an INFORMIX-4GL libraryC . in a user-defined error handler executed when the user presses the interrupt key when prompted for inputD . when the user presses the interrupt key when...
Which statement is true about the SERIAL data type?
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.View AnswerAnswer: C
Which parameters can be passed to a function?
Which parameters can be passed to a function?A . constantsB . concatenatorsC . date variablesD . array variablesE . integer variablesView AnswerAnswer: ACE
What does the DEFER INTERRUPT statement trap?
What does the DEFER INTERRUPT statement trap?A . only error statuses returned from the database engineB . only the interrupt key when the application is waiting for user inputC . either the interrupt or quit keys when the application is waiting for user inputD . both error statuses returned from...
