Gujarat University 2007 B.C.A Computer Application Computer Fundamental and Data Processing - Question Paper

FBCA-07
April-2007

Seat No. :

107 : Computer Fundamental and Data Processing


Time : three Hours] [Max. Marks : 70

Instructions : (1) Figure to the right shows full marks.
(2) Make and state any necessary assumption.

1. (A) Attempt the subsequent : (any ten) (10)

(1) DASD stands for .

(2) In processing data collection is usually done offline. (3) In multiprocessing more than 1 CPU are used. (True/False) (4) SPOOLING stands for .
(5) Differentiate ranging from data and info.
(6) Data need not be sorted for sequential file. (True/False) (7) is a volatile memory.


(8)


files are of permanent in nature, continuously updated by latest

transaction.

(9) All on-line systems are real time systems. (True/False)


(10)


is a system in which more than 1 programs can be executed

simultaneously by 1 processor. (11) What is utility software ?
(12) Write down the functionality of electronic pen.

(B) Attempt the subsequent : (any two) (4)

(1) Explain in brief (i) pen drive (ii) zip drive.
(2) Explain the terms : (i) USB
(ii) blue tooth.



2. (A) Attempt the subsequent : (any two) (10)

(1) Draw a block diagram to illustrate the basic organization of a computer system and discuss the functions of different units.

(2) Explain in brief (i) MICR and (ii) OCR.

(3) Give the kinds of software and discuss any 1 of them.

(B) Attempt the subsequent : (any two) (4)

(1) Write a brief note on palmtop computers.

(2) Explain the printing mechanism of inkjet printers. (3) What is ROM ? discuss PROM.


3. (A) Attempt the subsequent : (any two) (8)

(1) Explain data processing cycle with example. (2) Write a short note on.
(i) batch processing system and

(ii) multiprocessing system.

(3) List out different kinds of files and discuss any 2 of them.

(B) Attempt the subsequent : (any two) (6)

(1) Differentiate ranging from time sharing and real time processing. (2) Explain searching and sorting utilities of file.
(3) Explain Indexed Sequential Access File Organization.



4. (A) Attempt the subsequent : (any two) (8)

(1) Differentiate ranging from subsequent : (i) query and filter
(ii) list box and combo box

(2) Explain subsequent field property with example. (i) validation rule and validation text
(ii) input mask



(3) Explain subsequent terms with proper example.

(i) cascade update related fields and cascade delete related records. (ii) foreign key
(B) Attempt the subsequent : (any two) (6)

(1) Explain bound, unbound and computed control used in form generation. (2) Explain different SQL aggregate functions.
(3) Define macro and discuss any 4 actions of it.



5. (A) Attempt the subsequent : (any ten) (10)

(1) Primary key does not contain and values.


(2)

name is provided to macro if you want to run macro automatically

when the database is opened.

(3) What do you mean by orphan record ?

(4) Foreign key can contain null value. (True/False)

(5) Differentiate ranging from choose query and action query. (6) What is Dynaset ?
(7) What is the output of Date( ) ?

(8) More than 1 filter can be applied on a table. (True/False)

(9) property should be set to make field entry mandatory. (10) Differentiate ranging from linking and embedding.
(11) List out different choices for indexed property.

(12) Differentiate ranging from make table query and append query.

(B) Consider employee_detail table with subsequent fields. (4)

emp_id emp_name address city dob doj

department
salary
marital_status
job_category

Write SQL statement for the followings : (any four)

(i) Retrieve the department and maximum salary for every department.



(ii) Retrieve emp_id, emp_name, address, dob, department and job_category
whose dob is ranging from 1/2/06 and 1/8/06.

(iii) Retrieve all info about employees whose names start with the letter
‘R’.

(iv) Retrieve all records from the table and display this data sorted on the emp_name field in ascending order.

(v) Retrieve emp_id, emp_name, doj, department and salary who belong to purchase or sales department.

OR

(B) Define relationship and discuss every with proper example.

Earning:   Approval pending.