DOEACC Society 2006 DOEACC A Level A2-R3 Business Systems ( ) - Question Paper

C) has a default prompt which is "Press any key to continue…."
D) all of the above
1.10 The IIF( ) function
A) outcomes in compactness in a program
B) is used whenever you have both an "if true" and "if false" part of the statement
C) will work only if both are identical kind of expression
D) all of the above
A2-R3 Page two of six July, 2006
2. every statement beneath is either actual or FALSE. select the most improper one
and ENTER in the “tear-off” sheet attached to the ques. paper, subsequent
instructions therein. (1 x 10)
2.1 Data validation is generally accomplished by making use of different kinds of control totals.
2.2 The term stock includes manpower.
2.3 Balanced sheet indicates the company's health at any instant while profit and loss indicates the
company‘s performance.
2.4 A database file cannot be indexed on a logical field.
2.5 Structured programming diminishes the efficiency of coding of programs.
2.6 ??? will print the message in the identical line and directly on printer.
2.7 UNIQUE command can be used to prevent the display or access of the duplicate records.
2.8 A function such as UPPER( ) can be used while indexing a database file with INDEX.
2.9 The subsequent code:
Y="I am fine."
? LEN(Y)
will return the value as 8.
2.10SORT ON NAME + AMOUNT TO BANK is a valid command.
3. Match words and phrases in column X with the nearest related meaning/
word(s)/phrase(s) in column Y. Enter your selection in the “tear-off” ans sheet
attached to the ques. paper, subsequent instructions therein. (1 x 10)
X Y
3.1 Recovery from failure A. It is called as macro function
3.2 Vendor rating B. It is called as substring function
3.3 Aid to programming C. Check point restart
3.4 Create memory variable D. =
3.5 & E. Quality product
3.6 $ F. Allowing full screen editing of several records
3.7 APPEND BLANK G. It is string function
3.8 REPLICATE( ) H. Pseudocode
3.9 SET SCOREBOARD I. The command is used to determine whether
FoxPro compares 2 values with an exact match
or with the 1st letters only
3.10 SET EXACT J. It is string function to isolate a part of a string
K. Used to decide whether message of top line and
status bar have to appear
L. The command adds a new record to the bottom of
the database
A2-R3 Page three of six July, 2006
4. every statement beneath has a blank space to fit 1 of the word(s) or phrase(s) in

Earning:   Approval pending.