DISTANCE EDUCATION
B.Sc. (IT)/B.Sc. (Lateral) DEGREE EXAMINATION,
MAY 2016.
LAB IV VISUAL BASIC AND ORACLE
(2007 onwards)
Time Three hours Maximum 100 marks
Answer any TWO questions choosing ONE from VB
and another from ORACLE
Each question carries 50 marks.
Questions are to be selected by the examiner for
each candidate.
Write algorithm and flowchart if necessary
VB QUESTIONS
1. Write and test a VB program to select candidates for four
posts, based on their qualifications:
MALE AND PG DEGREE MANAGER
MALE, GRADUATE AND TYPING CLERK
FEMALE AND PG DEGREE SECRETARY
FEMALE, GRADUATE AND TYPING STENO
2. Write and test a VB program to display the Day and
Convert upper case from Lower case to give word.
Sub. Code
36
Cut here
DE-9176
2
sp4
3. Write and test a VB program to count number of words in
a given sentence. Use textbox for input.
4. Write and test a VB program to compute the surface area
and volume of a sphere given the radius. Use option
buttons and INPUT Boxes. (Formula A

3
V .
5. Write and test a VB program to compute and print either
sum of odd numbers or even numbers at the users choice
using label, text and option buttons.
ORACLE QUESTIONS
6. Create a table with the following structure
Field name Type Width Decimal
ENO Numeric 5
ENAME Character 25
BP Numeric 7 2
Add 5 records
Add the fields ALLOWANCES and DEDUCTIONS
Fill ALLOWANCES with 20% of BP for all
employees
Fill deductions with of BP for all employees
Compute Netpay (BP DEDUCTIONS
ALLOWANCES) and display all details along with
netpay for all employees.
Cut here
Cut here
Cut here
DE-9176
3
sp4
7. Create table MARKS with the following structure
Field Name Type Width Decimal
REGNO Numeric 8
NAME Character 20
MARK 1 Numeric 3
MARK 2 Numeric 3
MARK 3 Numeric 3
TOTAL Numeric 3
AVG Numeric 6
GRADE Character 1
Add 5 records
Replace all total with MARK 1 MARK 2
MARK 3 and display contents.
Replace all AVG with TOTAL/3 and display
contents.
Replace GRADE with the following
GRADE is A if AVG is greater than equal to 60
GRADE is B if AVG is 40 to 59, GRADE is C if AVG
is less than 40
Display the maximum marks in each subject.
Display the minimum marks in each subject.
Count the no of records for mark 1 50.
8. Create table with the following structure
Field name Type Width Decimal
ENO Numeric 5
ENAME Character 20
DEPARTMENT Character 15
SALARY Numeric 7 2
Add five records.
Display the name of employee who is getting
maximum salary.
Display all employee details who are belonging to
the department 'COMPUTER'.
Display the total no. of employees who are getting
more than 5000.
Replace all employee name with upper case.
Cut here
DE-9176
4
sp4
9. Create table BLOOD with the following structure.
Field name Type Width Decimal
DNO Numeric 3
DNAME Character 20
DOB Date
DAGE Numeric 2
DADD1 Character 15
DADD2 Character 15
DCITY Character 15
DPIN Numeric 6
DBLOOD Character 3
DSEX Character 1
Add 5 records.
Display all the records
Display the information of donors in the age group
20 to 25 using BETWEEN option.
Display the information of donors having date of
birth BETWEEN 01-JAN-55 and 31-DEC-75.
Display the information of donors having any of the
blood group from the set of blood groups using IN
option.
Display the information of female donors with age
between 20 and 25 using BETWEEN option.
10. Create table BIODATA with following structure
Field name Type Width Decimal
NAME Character 20
AGE Numeric 2
SEX Character 1
DEGREE Character 8
CITY Character 20
Add 5 records (BIODATA of 5 employees).
Display all records of MALE employees.
Delete all BSC degree holders and display the table
contents.
Remove all employee records who AGE is greater
than 50.
Display all employee records having AGE 50 and
CITY is TRICHY.