DISTANCE EDUCATION
B.Sc. (IT)/B.Sc. (Lateral) DEGREE EXAMINATION,
MAY 2018.
LAB IV — VISUAL BASIC AND ORACLE
(2007 onwards)
Time Three hours Maximum 100 marks
Instructions Examiner has to choose one question for
each candidate by LOT system.
Each subdivision carries 50 marks.
1. Write and test a VB program to print twenty
address labels in a two column format for the
address.
The Head of the Department
Anna University
Chennai.
Create table PERSONAL with the following fields
SNO, SNAME, CITY, PIN, PHONE with 5 records
and perform following
Display all names without duplicate
Display all names in uppercase, lowercase and
Initial Capital letters.
Display all names and length of names.
Sub. Code
36
DE-7023
2
wk11
2. Write and test a VB program to read in Principal,
Number of years and Rate of Interest through
INPUT Boxes, Compute and Print the Simple
Interest and Compound Interest through labels.
Create table MARK with the following fields
REGNO, NAME, TAMIL, ENGLISH, MATHS,
BIOLOGY
Show data in fields REGNO, NAME,TAMIL
MATHS alone on the screen
Show all fields in the screen
Show NAME and REGNO on the screen.
3. Write and test a VB program to computer the
surface area and volume of a sphere given the
radius. Use option button and INPUT boxes.
[Formula A 14R^3]
Create table RESULT with following fields REG
NO, NAME, MARKS, TOTAL and RESULT
Add 5 records except total and result
Calculate TOTAL with sum of MARKS
Fill the RESULT field with if TOTAL
150 else
DE-7023
3
wk11
4. Write and test a VB program to compute and print
either the SUM or the PRODUCT of the first N
natural numbers. Use option button.
Create table NUMB with NUM, ABSNO, SQRTNO,
ROUNDNO, TRUNCNO, SQRNO, CUBENO
Replace AESNO with absolute value of given
numbers.
Replace TRUNCNO by using TRUNC
function.
Replace CUBNO with cube of given numbers.
5. Write and test 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 table NUMB with NUM, ABSNO, SQRTNO,
ROUNDNO, TRUNCNO, SQRNO, CUBENO
Replace ABSNO with absolute value of given
numbers.
Replace TRUNCNO by using TRUNC
function.
Replace CURNO with cube of given numbers.
DE-7023
4
wk11
6. Write a VB program to do temperature conversion
C to F and F to Cat user's choice using Label, Text
and Enter Key.
Create table BIODATA with NAME, AGE. SEX,
DEGREE, CITY fields
Delete all BE degree holders and then display
the table contents.
Remove all employee records whose AGE is
lesser than 25.
Display all records having AGE<25 and CITY
is DHARAPURAM.
7. Write and test a VB program that allows the user
choice among four arithmetic operations of addition,
subtraction, multiplication and division with two
given numbers.
Create table LABEL with NAME, STREET, CITY,
PIN.
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-7023
5
wk11
8. Write and test a VB program to select candidates
for four posts, based on their qualifications.
MALE AND PG DEGREE MANAGER
MALE, GRADUATE TYPING CLERK
FEMALE AND PG DEGREE SECRETARY
FEMALE, GRADUATE TYPING STENO
Create table BLOOD with DNO, DNAME, DOB,
DAGE, DADD1, DADD2, DCITY, DPIN, DBLOOD,
DSEX
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-91 and
31-DEC-95.
Display the information of donors having any
of the blood group from the set of blood groups
using IN option.
9. Write and test a VB program to display the Day of
the given Date and Convert Upper Case from Lower
Case to given word.
Create table MARKS with REGNO, NAME,
MARKS, TOTAL, AVG, GRADE.
Replace TOTAL with sum of MARKS and
display the contents.
Replace GRADE with the following conditions.
GRADE is A if AVG is greater than or
equal to 60.
GRADE is B if AVG is 40 to 59.
GRADE is C if AVG is less than 40.
Count the number of records for mark 1>50.
DE-7023
6
wk11
10. Write a VB program to calculate Simple Interest or
Compound Interest using three command buttons
name Input, Calculate, Display.
Create table SALES with SALENo, SALENAME,
SALEAMT, COMM, SALEDATE
Replace COMM if sales amount is less than
1000 there is no commission or of sales
amount.
Display the records having commission <1000.
Display the Average sales and Average
commission.
11. Write and test a VB program that allows the user
choice among four arithmetic operations of addition,
subtraction, multiplication and division with two
given numbers.
Create table PAY with EMPNO, NAME, DOJ,
BPAY, DA, HRA, DEDU, GPAY, NPAY
Fill Data with 75% of BAY for all employees.
Fill HRA with 300 for all employees.
Fill DEDU with 750 for all employees.
Fill GPAY with the sum of BPAY, DA and
HRA.
Fill NPAY with GPAY-DEDU.