Gujarat University 2007 B.C.A Computer Application Business Data Processing – BDP (107) (Old ) - Question Paper

FBCA-07
April-2007

Seat No. :

Business Data Processing – BDP (107)
(Old Course)


Time : three Hours] [Max. Marks : 50


Instructions : (1) All ques. are compulsory.
(2) Figures to the right indicate full marks.




1. Do as Directed. (any ten) 10

(1) What is Primary key ? (2) Define : Seek time
(3) Define : Latency time

(4) In processing data collection is usually done offline.

(5) Minimum no of fields are needed for a cross tab query. (6) Give data structure hierarchy.
(7) IBG stands for .

(8) is a sequential access storage device.

(9) Primary key can be combination of more than on fields. (Rewrite as correct) (10) Multiprocessing works on the principle of interrupts. (True/False)
(11) What is the use of cascade update and cascade delete ? (12) discuss in brief Access naming conventions.
(13) is a sequential access storage device. (14) provide the full form of RDBMS.



2. Answer the subsequent : (any four) 10

(1) State and discuss the factors affecting file organization. (2) What is data structure? discuss it with life cycle.
(3) Describe the computer system also define its different parts and their functions in brief.

(4) What is data kind ? discuss every data kind of MS Access in brief. (5) Explain the concept of the distributed data processing.
(6) Write short note on multi programming.



3. Give the various of beneath topics (any four, 2 points of each) 10



(1) Text – Memo
(2) Bound – Unbound controls
(3) Select Query – Action Query
(4) Forms – Report
(5) DBMS – RDBMS
(6) Batch – Real time processing


(A)

4. Attend any three.


(1) Explain various methods of data processing.

(2) Explain Direct access file organization with example.

(3) Compare and contrast : Multi programming and Multiprocessing.

(4) Explain Validation rule, Validation text and Index.

(B) Give only use of beneath terms. 1

(1) Macro

(2) Filter

(3) Required

(4) Referential Integrity



5. (A) Attend the subsequent : (any two) 5

(1) State and discuss various types of relationships in detail with example. (2) Compare and contrast : Data – info
(3) What is file and file organization ? discuss different kinds of file in brief.

(B) Attend the subsequent in detail. (any one) 5

(1) Describe Data-processing cycle along with diagram and example. (2) Write advantages and disadvantages of Electronic Data processing.

Earning:   Approval pending.