Computer Model Test Paper 6 for B.Sc Final Year Examinations conducted by various Universities, Colleges from India

Home / Model Test Papers / B.Sc / Final Year / Computers Paper 3 / Model 6

Search these pages / web / Questions/Enquries

1.
(a) Indicate the purpose of each of the divisions in a COBOL Program (10)
(b) COBOL is best suitable for commercial applications. Justify it. (10)

2.
(a) State the rules for defining valid datanames in COBOL and give some examples. (6)
(b) Explain the purpose of PICTURE and VALUE Clauses. (8)
(c) Define the terms group items and elementary items. (6)

3.
(a) Give in general the method of describing the structure of a tree in COBOL. (8)
(b) Explain why GOTO is not a desirable constructut for programming. (6)
(c) Using OCCURS clause write WORKING-STORAGE SECTION entries to initialise the 7 elements of a table as SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY and SATURDAY.

4. A bank has the following policy of Deposits. On deposits of Rs. 6000 or above for 3 years or above the intrest rate is 11%. On deposits of Rs. 6000 and above but below 3 years the intrest rate is 8 % On deposits below Rs. 6000 regardless of the period the intrest rate is 7 %. The Input record format is

DEPOSITOR-NO    	1-5
NAME		6-31
AMOUNT-OF-DEPOSIT	32-37 (Rupees)
PERIOD		38-39 (years)

Write a COBOL program which will give an output record with above information and two more additional fields. One with intrest on deposits and the other with net amount in account. (20)

5. Draw a flow chart to update a sequentially organised master file using a transaction-file. Create a new master file by performing the following operations on old master.

IF TRANS-CODE is 1 add a record, 2 delete a record, modify the record.

( State clearly your assumptions if any )

6. (a) Write about the facilities that are available in COBOL for sorting and merging of auxillary storage files. (15)

(b) Write briefly about the usage of REDEFINES clause.

7. (a) Define the terms : database, schema and sub-schema

(b) Explain about the relational, hierarchial and network models of database.

8. (a) Write about the advantages and disadvantages of using SORT and INDEX commands in dBASE. (8)

(b) In detail, specify how to handle multiple databases in dBase and also explain the use of SET RELATION, UPDATE and JOIN Commands. (12)