Veer Narmad South Gujarat University 2011-1st Year B.C.A Computer Application SD-1434 206 Practical ( Sem - 2 ) - Question Paper
SD-1434
First Year B. C. A. (Sem. II) Examination
April/May - 2011
206 - Practical
[Total Marks : 140
Time : 5 Hours]
Instructions :
(1)
6silq<3i Puunkiufl SnwiA u* qsq d-onql. Fillup strictly the details of signs on your answer book.
Name of the Examination :
FIRST YEAR B. C. A. (SEM. 2)
Name of the Subject:
206 - PRACTICAL
-Subject Code No. |
|
-Section No. (1,2,.....) |
""'N Seat No.:
Student's Signature
NIL
(2) Figure on the right indicate marks.
1 Write a C program to Reverse the Digit of the Number(ex : if u enter 1234 [25] the output would be 4321 )
2 Write a C program to read a sentence (containing blank spaces) and count [25] the no. of words in it.
3 Student (roll_no, name, gender, address, class) [40] Marks (roll no, subl, sub2, sub3, total, per)
Give Primary key and other constraints to each table
(1) Display the students ofFYBCA
(2) Display the marks of students whose roll no is 45 and class is SYBCA
(3) Count the number of girls from SYBCA
(4) Count the nouber of students scored distinction in TYBCA
(5) Give details of student who has stood first in each class.
(6) List the percentage of students passed in SYBCA, FYBCA and TYBCA>
(7) Count the number of boys securing first class, (>= 60% and <
70%)
(8) List the students who have failed, (less than 40%)
(9) Display the student name start with J.
(10) Find the student name and class of student where the student name has Patel as sub string
Purchases |
14,000 |
Sales |
18,400 |
Purchase Return |
700 |
Sales Return |
1,100 |
Mr. Shyam (Cr.) |
1,000 |
Ms. Radha (Dr.) |
6,220 |
Furniture |
900 |
Stationery Expense |
200 |
Advertisement Expense |
240 |
Mrs. Sita (Cr.) |
520 |
Traveling Expense |
240 |
Stock |
10,000 |
Rent |
300 |
Discount Allowed |
200 |
Salaries |
400 |
Machinery |
3,600 |
Raj Stores (Dr.) |
800 |
Manish (Cr.) |
2,800 |
Capital |
24,000 |
Loan Taken |
600 |
P.F | | |
500 |
Wages |
160 |
Bank |
7,000 |
Cash |
2,400 |
Drawings |
1,000 |
Interest received |
100 |
Discount received |
140 |
Viva + Journal. [20]
SD-1434] 2 [ 700 ]
Attachment: |
Earning: Approval pending. |