Gujarat University 2009-1st Year B.C.A Computer Application Computer Fundamental and Data Processinng - Question Paper
|
Time: 3 Hours] |  |
All questions are compulsory. Ail questions cany' equal marks. Draw diagrams when necessary'.
Instructions:
(1)
(2)
(3)
1. (A) Answer in brief:
10
Write names of two parts of CPU.
l.
2.
3.
4.
5.
6.
7.
8. 9.
10.
11.
12.
13.
14.
Full form of EEPROM.
Third Generation computers uses_as major technology.
Write what information is confirmed in program control register. What is Disk Array ?
Write names of various types of impact printers.
List types of S/W.
Give major difference between online & batch processing.
Write advantage of Wi-Fi.
Dynaset.
Filter Vs. Query.
Draw design view of following query.
Select dcpt_code, count(emp_code)
From employee Group by dcpt_code;
List types of relationships with examples.
List Datatypes available in MS-Access.
(B) Describe in detail: (any 1)
(1) Block diagram of computer.
(2) Compare Personal Computer, Laptop and Palmtop.
2. (A) Write short notes : (any 4) 8
1. . Explain MICR & its use
2. Explain file merging and matching
3. Explain drum printer
4. Plotter
5. Types of flies A
(B) Write short notes : (any 2) 6
1. Explain USB
2. Screen image projector
3. Access mechanism of optical disk
2022-B 1 P.T.O.
Describe tn detail: (any 2)
1. Sequential and direct access file organization.
3. (A)
(B)
2. Grid computing.
3. Advantages and disadvantages of EDP.
Describe in detail with example: (any 1)
1. Modular programming
2. Index sequential file organization
Describe in detail: (any 2)
4. (A)
,(B)
1. Action Query
2. Input mask characters
3. Filters
Write short notes : (any 2)
1. Macro
2. Aggregate functions
3. Linking & Embedding
Write short notes: (any 3) ,
5. (A)
1. Find duplicate, find unmatched J \i -
2. Crosstab Query '
3. Controls available in forms ft
4. Referential integrity
Write SQL view for foliowing.queries :
Table: student
Fields: si_no, stname, st_gender, st_phone. st_mobile, st_email, st_resuU, st_slream.
1. Display genderwise count of students.
2. Display result of commerce stream in descending order.
3. Increase result by 10% of all female students.
4. Display details of student whose name contains the character entered by the user.
5. Display student details of PH category and scored at least 60% of marks.
|
Attachment: |
| Earning: Approval pending. |
