DOEACC Society 2007 DOEACC A Level A2-R3 Business Systems - Question Paper
Thursday, 13 June 2013 08:50Web
Page 2 of 2
ALTERNATE TO
A) SET ALTERNATE OFF
B) CLOSE DATABASES
C) CLOSE ALTERNATE
D) CLEAR ALL
1.10 The replace command is used to
A) replace the structure of a database file
B) replace a report format file
C) Add a new field to every record of a database file
D) None of the above
A2-R3 Page two of five January, 2007
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 Capital is a liability head.
2.2 Leave record, though a function in personnel management does not form part of the
payroll system.
2.3 A credit purchase transaction increases the liability of a company.
2.4 For carrying out historical analysis, previous year consumption is stored in the item
master file.
2.5 Invoice detail file is a master file in a sales invoicing system.
2.6 If RATE is a numeric field, LIST RATE/1.1 is invalid.
2.7 Up to 10 database files can be opened in a work area.
2.8 A function such as UPPER( ) can be used while indexing a database file with INDEX.
2.9 1 can create an index tag while defining the structure of the database file.
2.10 STORE[20] TO NUM creates a character variable.
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 Ageing Analysis A. Pseudo code
3.2 P & L of operations B. Delivery timeliness
3.3 LIFO C. Merge in Balance Sheet
3.4 Vendor rating D. INPUT
3.5 Aid to programming E. Debtor Control
3.6 Created numeric variable F. VALID
3.7 @..GET G. Inventory evaluation
3.8 .SPR H. OTHERWISE
3.9 DO CASE I. choose
3.10 NO DELETE J. BROWSE
K. Screen file
L. @..SAY..GET
A2-R3 Page three of five January, 2007
4. every statement beneath has a blank space to fit 1 of the word(s) or phrase(s) 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. Operating profit B. Payroll C. Software
D. Semantics E. Utility Programs F. Customer details
G. Key H. Module I. Indexed
J. Zero K. Net Profit L. GO TO
4.1 A portion of a program that performs a specific program function is called ________.
4.2 ________ is the difference ranging from gross profit and operating expenses.
4.3 Typically, a computer based provident fund system uses inputs from the computerised
________.
4.4 A unique identifying value that is obtained in very record in a file is called a record
________.
4.5 Routine and mundane tasks such as sorting, copying etc. are done by ________.
4.6 Study of the meaning of the language structure is called the ________ of the language.
4.7 A database management system is essentially a specialized kind of ________ package.
4.8 ________ file is a master file in a sales invoicing system.
4.9 To use the LOCATE command, the database file need not be sorted or ________.
4.10 ________ statement is not desirable in a structured program.
A2-R3 Page four of five January, 2007
PART TWO
(Answer any 4 questions)
5.
a) What is meant by data processing?
b) How is database various from a file?
c) What is a sequential file? How do we decide to use a particular file organization for an
application?
(4+4+7)
6.
a) What is database? Briefly define the characteristics of the database.
b) What is RDBMS? Mention any 4 advantages of the RDBMS.
(8+7)
7.
a) What is a report generator? discuss.
b) Distinguish ranging from Structured Programming and Modular Programming.
c) Distinguish ranging from Sorting and Indexing.
(5+5+5)
8. Write SQL commands for a) to f) and write the output of g) on the basis of table MOV.
No. Name kind Rating Stars Qty. Price
1. Gone with the wind Drama G Gable four 39.95
2. Friday the 13th Horror R Jason two 60.95
3. Top Gun Drama PG Cruise seven 49.95
4. Splash Comedy PG13 Hanks three 29.95
5. Independence Day Drama R Turner three 19.95
6. Risk Business Comedy R Cruise two 44.95
7. Cocoon Sci-fi PG Ameche two 31.95
8. Crocodile Dundee Comedy PG13 Harris two 69.95
9. 101 Dalmatians Comedy G Hoffman three 59.95
10. Tootsie Comedy PG Croft one 29.95
a) obtain the total value of the movie cassettes available in the library.
b) Display a list of all movies with price over 20 and sorted by Price.
c) Display all the movies sorted by QTY in decreasing order.
d) Display a report listing a movie number, current value and replacement value for every
movie in the above table. compute the replacement value for all movies as QTY * Price
* 1.15.
e) Count the number of movies where Rating is not “G”.
f) Insert a new movie in the MOV table. Fill the entire column with a few values.
g) provide the output of the subsequent SQL statement.
i) choose MAX(Price) from MOV where Price > 30.
ii) choose SUM(Price * QTY) from MOV where QTY < 4.
iii) choose COUNT(DISTINCT TYPE).
(2+2+2+2+2+2+3)
9. A database table called PERSON contains the fields NAME, BASIC and HRA. Write a
computer program to print a report with employee name and total salary for those
employees whose total salary is more than 10,000. Total Salary = BASIC + HRA. At the
end, the program should also print the total number of employees whose total salary is
more than 10,000.
(15)
A2-R3 Page five of five January, 2007
| Earning: Approval pending. |
