Veer Narmad South Gujarat University 2011-1st Year B.C.A Computer Application SD-1434 206 Practical ( Sem - 2 ) - Question Paper

Friday, 26 April 2013 05:20Web

Page 1 of 2

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.

1

4

3

4

-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