FACULTY OF SCIENCE
B.Sc. III Year (Practical)
Examination
Subject : Computer Science (New
Syllabus)(With Effect From Annual
2011)
Paper – III : D B M
S
QUESTION BANK
Time : 3 hours Max. Marks :
50
Note : Answer any one
question.
Section-A
Employee (SQL)
Database
An Enterprise wishes to maintain a database to automate its
operations.
Enterprise is divided into certain departments and each department
consists
of employees. The following two tables describes the automation
schemas
Dept (deptno, dname,
loc)
Emp (empno, ename, job, mgr, hiredate, sal, comm,
deptno)
1. Find out the details of top 3 earner of
company.
2. Display those managers name whose salary is more than
averagesalary of his
employees.
3. Display those employees who joined the company before 15th of
the
month?
4. Display the manager who is having maximum number of
employees
working under him?
5. Print a list of employees displaying ‘less salary’ if less
than 1500 if exactly 1500 display as ‘Exact salary’ and if greater than
1500
display ‘more
salary’?
6. Update the employee salary by 15%, whose experience is
greater than 10
years.
7. Delete the employees, who completed 30 years of
service.
8. Determine the minimum salary of an employee and his details,
who joined on the same
date.
9. Determine the count of employees, who are taking
commission.
10. Create a view, which contain employee names and their
manager
names working in sales
department.
11. Determine the names of employee, who earn more than
their managers
.
12. Determine the names of employees, who take highest salary
in their
departments.
13. Determine the employees, who are located at the same
place.
14. Determine the employees, whose total salary is like the
minimumSalary of any
department.
15. Determine the department which does not contain any
employees.
Section-B
(PL/SQL)
16. Write a Pl/Sql program to raise the employee salary by 30%,
who have completed their 40 years of
service.
17. Write a Pl/Sql program to check the given number is
Armstrong
‘or’ not.
18. Write a Pl/Sql program to display top 10 rows in emp table
based on their job and
salary.
19. Write a Pl/Sql program to swap two numbers without using
third variable
.
20. The hrd manager has decided to raise the employee salary by
20%. Write a Pl/Sql block to accept the employee number and update
the
salary of that employee. Display appropriate message based on
the
existence of the record in emp
table.
21. Write a Pl/Sql program to generate multiplication tables for 3
& 7.
22. Write a Pl/Sql program to display sum of prime numbers and sum
of
composite numbers in the given
range.
23. Write a Pl/Sql trigger on the emp table when ever an update
is performed on the emp
table.
24. Write a Pl/Sql program to raise the employee salary by 10%,
for department number 30 people and also maintain the raised details
in
the raise
table.
25. Write a procedure to update the salary of employee, who are
not getting commission
9%.
26. Write Pl/Sql program to check the given string is palindrome
or not.
27. Write a Pl/Sql procedure to prepare a telephone bill by
using following table. And print the monthly bills for each
customer
Table used : phone.
Name null?
Type
----------------------------- --------
----------------------
Tel_no not null number(6)
Cname
varchar2(20)
City varchar2(10)
Pr_read
number(5)
Cur_read
number(5)
Net_units
number(5)
Tot_amt number(8,2)
28.Write a procedure to update the salary of employee, who belongs
to
marketing department with a 15% percentage of
raise.
29.Write a Pl/Sql procedure to prepare an electricity bill by
using following
table
table used:
elect
name null?
Type
----------------------------------
-mno not null number(3)
cname
varchar2(20)
cur_read
number(5)
prev_read
number(5)
no_units number(5)
amount number(8,2)
ser_tax number(8,2)
net_amt number(9,2)
30. Write a Pl/Sql program to retrieve data from emp table
using cursors
.
*****
