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

the list beneath. Enter your option in the “tear-off” ans sheet attached to the
ques. paper, subsequent instructions therein. (1 x 10)
A. Weighted avg. B. .F. C. CEILING( )
D. Distributed E. change F. Assets
G. Centralized H. Dummy I. General ledger system
J. .T. K. FLOOR( ) L. Subsidiary ledgers
4.1 Loans to employees form part of_________.
4.2 evaluation of stock can be done by using _______ method.
4.3 Computerized Railway Reservation System is an example of _________data processing
system.
4.4 In a function, if we omit the RETURN in the end, a default value of _______ is returned
to the main program.
4.5 The ________ command will bring universal change to all records.
4.6 With the use of _______function, you can obtain out the closest integer which is less than
or equal to the specified number.
4.7 A special field can be placed in a ________ record at the end of a file to indicate that all
valid records have been processed.
4.8 With the use of _______function, you can obtain the next higher integer that is more than
or equal to the specified number.
4.9 Capital + Liability - ________= Zero.
4.10 Examples of high quantities transactions are__________.
A2-R3 Page four of six July, 2006
PART TWO
(Answer any 4 ques..)
5.
a) What is the difference ranging from an output file and a report file? discuss with suitable
examples.
b) elaborate the 2 standard methods used in data processing systems for organizing
data? discuss their relative advantages and disadvantages.
(5+10)
6.
a) define briefly the different kinds of fields supported in FoxPro.
b) discuss the roles of data files and index file in indexed sequential file organization.
c) What is report generator? What is its role in the overall design and/or usage of a
database?
(5+5+5)
7.
a) discuss the following:
i) INLIST( ) function
ii) SUBSTR( ) function
iii) TRIM( ) function
iv) CTOD( ) function
v) DATE( ) function
b) What is SQL? discuss the choose statement with example.
c) What is object linking and embedding? provide a suitable example in support of your
explanation.
(5+5+5)
8. discuss the following:
a) elaborate Visual FoxPro forms? List out features that may be incorporated into form to
facilitate easier data entry.
b) Write a procedure in FoxPro to reverse the 1st and last names of customers, which are
separated by a comma and 1 space. presume the field name to be NAME in a
database called CUSTOMER.
c) What is Mail Merge Wizard? discuss it.
(6+6+3)
9. A college conducts entrance exam for admitting students into a course. The
subsequent 2 tables are used for rank processing.
learner MASTER MARKS MASTER
S_NO C (4) S_NO C (4)
PERCENTAGE N (5, 2) SCORE N (5, 2)
EXP_MON N (3)
TOTAL N (6, 2)
RANK N (2)
A2-R3 Page five of six July, 2006
S_NO is the primary key. PERCENTAGE is percentage of marks found in the
qualifying exam. EXP_MON is the work experience in months. TOTAL= SCORE +
PCR + ECR. For evaluating PCR and ECR use the subsequent table. RANK is candidate's
position based on the score in entrance examination. The SCORE is marks found by the
candidate in entrance examination. The subsequent credits are provided to the learner based on the
percentage of marks and work experience.
PERCENTAGE EXP_MON
>80 PCR=3 >=120 ECR=3
>65 & <=80 PCR=2 >=60 & <120 ECR=2
>=50 & <=65 PCR=1 >=24 & <60 ECR=1
Write a program in Visual FoxPro to compute and print rank based on TOTAL.
(15)
A2-R3 Page six of six July, 2006

Earning:   Approval pending.