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

3.1 Inventory valuation A. The choose command
3.2 Loan to employees is recorded in B. Uses data from an existing database file as the basis for modifications to data records in the active database file
3.3 Skills Inventory C. Working capital
3.4 Hash totals D. Subsidiary Ledger
3.5 Current assets E. Personnel Systems
3.6 Selects a work area F. It is used to remove the trailing blanks from a character string.
3.7 SET RELATION G. Causes an active database file to appear to contain only the records meeting the specified condition.
3.8 TRIM( ) H. Validation
3.9 UPDATE I. Links the active database file to a different open database file according to key expression that is common to both files.
3.10 SET FILTER J. LIFO
K. Random access
L. Low Inventory Storage
M. Payroll Systems
N. SKIP



























4. Each statement beneath has blank space to fit 1 of the word(s) or phrases in the list beneath. Enter your option in the “tear-off” ans sheet attached to the ques. paper, subsequent instructions therein. (1 x 10)

A. Record key B. Buffer stocks
C. Trial balance D. Subsidiary ledger
E. Pseudocode F. Loop
G. ABC Analysis H. Utility programs
I. Top down J. Testing
K. Dummy L. Transaction
M. Books of accounts N. Balance sheet

4.1 In a _______ approach, the main program is decomposed into progressively lower level modules.
4.2 At the end of every year the accountant carries the balance of Profit and Loss Account to _______.
4.3 A(n) _______ is a listing of the ledger of accounts, along with their net dibit or credit balances.
4.4 The process of executing the developed programs with different data inputs in order to detect programming errors or an omission is called as _______.
4.5 An unique identifying value that is obtained in every record in a file is called as a _______.
4.6 Purchases from vendors form part of the _______.
4.7 Variations in demand of a product are taken care by carrying _______.
4.8 _______ is a programming term used to represent a set of instructions in a programme, which is to be repeated.
4.9 the _______ indicates classification of different stock items on the basis of their values.
4.10 A term that defines program segments written in ordinary language, rather than in a programming language is _______.























PART TWO
(Answer ALL questions)

Earning:   Approval pending.