DOEACC Society 2007 Advanced Level Course In Computer Science A2-R3: BUSINESS SYSTEMS - Question Paper

1.2 A sequential file organization is suited for
A) Examination processing
B) Airline reservation system
C) Online trading of shares
D) Monitoring the movement of a satellite

1.3 In a payroll system, the year-end processing will include
A) Provident fund contribution statement for the last month
B) Income Tax statement for the year
C) Pay slip for the last month
D) All of the above

1.4 Employee advances are generally
A) Kept in the subsidiary account
B) Not incorporated in financial accounts
C) Are part of the memorandum accounts
D) None of the above











1.5 In an accountant’s system, collection of all temporary and permanent accounts is maintained in the
A) Cash journal
B) General ledger
C) Accounts payable component
D) Double entry balance system

1.6 The command DISPLAY STRUCTURE will:
A) List the structure of the database file in use
B) List the structure of the index file in use
C) List the structure of the command file in use
D) List the structure of all active files in use

1.7 SET UNIQUE command
A) Used along with the INDEX command to exhibit an ordered listing of unique field values
B) Used along with the SORT command to exhibit on ordered listing of unique field values
C) Can be used both with INDEX and SORT
D) Is exclusively used with BROWSE command to edit an ordered listing of unique field values

1.8 The command SORT ON NAME/D TO TEMP will
A) Arrange the sorted data in descending order
B) Delete the unsorted data after arranging it in descending order
C) Download the sorted names from a web site
D) None of the above

1.9 ? STUFF ("Baba",3,2,"by") returns
A) baby
B) Byby
C) Baby
D) Babbya

1.10 Consider the subsequent code:
Status = IIF(debit>=credit, "Amount due", "Credit")
The above code is equivalent to:
A) IF debit>= credit
Status = "Amount due"
ELSE
Status = "Credit"
ENDIF
B) IF debit>= credit
Status = “Credit”
ELSE
Status = "Amount due"
ENDIF
C) Both A) and B) above are accurate
D) There is no equivalence of the code listed in the issue.










2. Each statement beneath is either actual or FALSE. select the most improper 1 and ENTER in the "tear-off" sheet attached to the ques. paper, subsequent instructions therein. (1 x 10)

2.1 In a real-time system, all modifications are recorded on an online transaction file and the master file updated for report production when needed.

Earning:   Approval pending.