SEE Computer Science External Practical Question Model 

 

Group “A”

(MS Access - 10 Marks)

 

1.  a)   Create a MS-Access database "exam.mdb" and create a table named "student" under the database "exam.MDB" with the following structure: (2)

Field name	Data type
Roll no	Number (PK)
Sname	Text
Gender	Yes/no
Date of birth	Date/time
Detail	Memo
English	Number
Maths	Number
Computer	number

 

b) Add five records in the "student" table.    (2)

c) Prepare a Query to display records that contain Roll no, English, Math, Computer fields of data only.  (2)

d) Prepare a Query to display the records of male students only (or whose Gender is TRUE)  (2)

e)  Prepare a report on the basis of above table that contains Roll no, Sname, Gender, DOB fields of data (Using wizard)                         (2)

 

Group “B”

(QBASIC - 9 Marks)

2.  a.  Write a QBASIC sub program to find simple interest. (3)

b.  Write a program in QBASIC using Function … End Function to reverse a given string. (3)

c.  Create a data file named “school.txt” which stores Student name, class, address and email. Program should be stop according to the user choice  (3)

Group “C”

(C Programming - 6 Marks)

3. a.  Write a program to display the smallest number among three different numbers. (3)

b. Write a program to display the series 1 1 2 3 5 8 ……… up to 10th terms. (3)