DISTANCE EDUCATION
B.Sc. (CS)/B.Sc. (Lateral) DEGREE EXAMINATION,
MAY 2016.
LAB IV — VISUAL BASIC AND ORACLE
(2007 onwards)
Time Three hours Maximum 100 marks
Examiner has to select TWO questions. One from Visual Basic
and another from Oracle. The questions are given to the
student by lot system.
Each sub division carries 50 marks.
VISUAL BASIC
1. Write the test a VB program to compute the intervals
between two dates in terms of day, months and years.
Use option buttons, text boxes and command buttons.
2. Write a VB program to display and calculate simple
interest or compound interest using three command
buttons namely Input, Calculate, Display.
3. Write a VB program to do temperate conversion C to F
and F to C. Use option buttons and input boxes.
Cut here
Sub. Code
36
Cut here
DE-9171
2
4. Write and test a VB program to compute and print either
sum of odd numbers or even numbers at the user's choice
using Label, Text, Option buttons.
5. Write and test a VB Program to print twenty address
labels in a two-column format for the address.
THE REGISTRAR
ALAGAPPA UNIVERISTY
KARAIKUDI 630003.
6. Write and test a VB program to compute the surface area
and volume of a cylinder given radius and height. Use
option buttons and input boxes.
7. Write a VB program to compute and print the product of
the first N natural numbers. Use option button.
8. Write a VB program that allows the user choice among
four arithmetic operations and with given two
numbers. Use option buttons and input boxes.
Cut here
Cut here
Cut here
Cut here
DE-9171
3
ORACLE
9. Create table NUMB with the following structure
Field Name Type Width Decimal
NVM 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
decimal).
Display all the records.
Replace ABSNO with absolute value of given
numbers.
Replace SQRTNO with square root value of given
numbers.
Replace round No by using ROUND function.
Replace TRUNCNO by using TRUNC function.
Replace SQRNO with the square of given numbers.
Replace CUBNO with CUBE of given numbers.
Display all the records.
DE-9171
4
10. Create a table BIO-DATA with the following structure
Field Name Type Width Decimal
Name Char 25
Age Numeric 2
Sex Char 1
Degree Char 8
City Char 20
Add 5 records (BIO-DATA of 5 employees).
Display all records of MALE employees.
Delete all B.Sc. 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
TIRUNELVELY.
11. Create table MARK with the following structure
Field name 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 and REGNO alone on
the screen.
Show all fields on the Screen.
Cut here
DE-9171
5
12. Create table with the following structure
Field name Type Width Decimal
SNO Numeric 5
SNAME Character 25
SAMT Numeric 8 2
COMM Numeric 6 2
Add 5 records.
Display the salesman details whose sales amount is
maximum.
Replace the with if sales amount is less
than 1000; 10% of sales amount if sales amount is
above 1000 and below 10,000; 15% of sales amount
if sales amount is equal to or above 10000.
Display all records.
Display the records having commission 1000.
13. Create table Bank with following structure
Field name Type Width Decimal
ACCOUNT NO Numeric 10
CNAME Character 25
TYPE Character 1 (D-Deposit
DATE Date W-Withdraw)
AMT Numeric 5
BALANCE Numeric 8 2
Insert 5 records.
Display all transactions with Type is
Display all transactions belonging to the customer
with the account number
Display all the transactions on the date 10-Dec-2008.
List all details whose balance is above 5000 on
15th March 2009.
Cut here
DE-9171
6
14. Create table ADDRESS with the following structure
Field name Type Width
NAME Character 25
STREET Character 30
CITY Character 20
PINCODE Numeric 6
Add 5 Records.
Display the structure of the table.
Add the field DISTRICT.
Fill all DISTRICT with KARAIKUDI.
Change the pincode to 630003 where the city is
Karaikudi with pincode as 630003.
15. Create a VENDOR table with the following details
Field name Type Width
VENDOR NAME Varchar 20
VENDOR NO Varchar 10
ADDRESS Varchar 10
CITY Varchar 15
STATE Varchar 15
PRODUCT NAME Varchar 15
Add 8 Records.
Change the width of the address field to 30.
Display VENDOR NO, VENDOR NAME,
ADDRESS, CITY for Tamilnadu State.
Display the Vendor details who supply the Laptop.
Display the distinct VENDOR NAME.