DISTANCE EDUCATION
B.Sc. (Computer Science)/B.Sc. (Computer Science) (Lateral)
DEGREE EXAMINATION, DECEMBER 2017.
LAB IV VISUAL BASIC AND ORACLE
(2007 Onwards)
Time Three hours Maximum 100 marks
Examiner has to select ONE question and give it to the
student by LOT system.
Each question has two subdivisions.
1. Write a VB program to read in principal, number of
years and rate of interest through INPUT Boxes.
Then, compute and print the simple interest and
compound interest through labels.
Create a table ADDRESS with the following
structure.
Fieldname Type Width Decimal
Name Character 20
Street Character 20
City Character 20
Pin Numeric 6
Add 5 Records
Display the structure of the table
Add the field DISTRICT
Fill all DISTRICT with MADURAI
Change the PIN to 630003 where city is
KARAIKUDI and PIN is 623003.
Sub. Code
36
DE-9817
2
Sp 1
2. Write a VB program to compute the surface area
and volume of a sphere for the given radius. Use
Option buttons and INPUT Boxes.
Create a table MARK with the following structure:
Fieldname Type Width Decimal
REGNO Numeric 8
NAME Character 20
TAMIL Numeric 3
ENGLISH Numeric 3
MATHS Numeric 3
BIOLOGY Numeric 3
Add 5 Records.
Show data in fields REGNO, NAME. TAMIL
and BIOLOGY alone on the screen.
Show data in fields REGNO, BIOLOGY and
MATHS alone on the screen.
Show data in fields NAME REGNO alone on
the screen.
Show all fields on the screen.
DE-9817
3
Sp 1
3. Write a VB program to compute the surface area
and volume of a sphere for the given radius. Use
Option buttons and INPUT Boxes.
Create a table RESULT with the following structure.
Fieldname Type Width Decimal
REGNO Numeric 8
NAME Character 20
MARK 1 Numeric 3
MARK 2 Numeric 3
MARK 3 Numeric 3
Total Numeric 3
Result Character 4
Add 5 records (Fill all Fields except Total and
Result fields)
Fill TOTAL field with the sum of MARK
MARK 2 and MARK 3.
Fill the RESULT field with if TOTAL
150 otherwise
DE-9817
4
Sp 1
4. Write a VB program to compute and print either the
sum of odd numbers or even numbers at the user's
choice using Label, Text and Option buttons.
Create a table BIODATA with following structure,
Fieldname Type Width Decimal
NAME Character 25
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 then
display the table contents.
Remove all employee records whose AGE is
greater than 20.
Display all records having AGE 20 AND
CITY is TRICHY.
DE-9817
5
Sp 1
5. Write a VB program to calculate simple interest or
compound interest using three command buttons
namely input, calculate and display.
Create table LABEL with the following structure
Field name Type Width Decimal
NAME Character 20
STREET Character 20
CITY Character 20
PIN Numeric 6
Add 5 Records.
Display the contents of the table.
Display the Ascending order sorted list with
NAME as primary key.
Display the Descending order sorted list with
CITY as primary key.
Display the contents with appropriate
HEADINGS.
DE-9817
6
Sp 1
6. Write a VB program to input two numbers and
perform any one of the four arithmetic operations
like addition, subtraction, multiplication and
division as per user's choice.
Create a table PERSONAL with the following
structure.
Field name Type Width Decimal
SNO Numeric 8
NAME Character 20
CITY Character 20
PIN Numeric 6
PHONE Numeric 6
Add 5 Records
Display the contents of the table.
Display all names.
Display all names without duplicate.
Display all names in uppercase, lowercase and
Initial Capital letters.
Display all names and length of names.
Display name, city in which only beginning
portion of name is known.
DE-9817
7
Sp 1
7. Write a VB program to compute and print either the
sum of odd numbers or even numbers at the user's
choice using Label, Text and Option buttons.
Create a table BLOOD with the following structure.
Field name Type Width Decimal
DNO Numeric 3
DNAME Character 20
DOB Date
DAGE Numeric 2
DADD 1 Character 15
DADD 2 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.
DE-9817
8
Sp 1
8. Write a VB program to compute and print either the
SUM or the PRODUCT of the first N natural
numbers. Use option button.
Create a table NUMB with the following structure
Field name Type Width Decimal
NUM Numeric 6 2
ABSNO Numeric 6 2
SQRTNO Numeric 6 2
ROUNDNO Numeric 6 2
TRUNCNO Numeric 6 2
SQRNO Numeric 6 2
CUBENO Numeric 6 2
Add 5 Records. (Some numbers must be
negative or decimal)
Display all the records.
Replace ABSNO with absolute value of given
numbers.
Replace SQRTNO with square root value of
given numbers.
Replace ROUNDNO by using ROUND
function.
Replace TRUNCNO by using TRUNC
function.
Replace SQRNO with square of given
numbers.
(viii) Replace CUBENO with cube of given
numbers.