Friday, December 18, 2015

ORACLE,2010 Question Paper,University Of Pune Question Paper,P. G. D. C. A. (Semester - III)

University Of Pune Question Paper
P. G. D. C. A. (Semester - III) Examination - 2010
ORACLE
(New 2008 Pattern)
Time : 3 Hours] [Max. Marks : 70
Instructions :
(1) Question No. 1 is compulsory.
(2) Solve any five questions from the remaining.
(3) Figures to the right indicate full marks.
Q.1) Consider the following table structure to write SQL queries : [20]
Emp Table :
empno number(3), ename varchar2(30), sal number(4), comm
number(3), job varchar2(10), deptno number(2), joindate date,
address varchar2(30), mgr number(3)
Dept Table :
deptno number(2), dname varchar2(30), location varchar2(30)
(a) Display managers having 2 subordinates.
(b) List employee name and his manager name.
(c) Display all employees who joined organisation in the month
of March.
(d) Display name of the department having highest no. of
employees.
(e) Display managers having salary more than 5,000.
(f) Display empno, name, department name and annual salary for
all employees.
(g) List employees working in SALES Department.
(h) Display name of the person getting highest salary.
(i) Display name of the employees not getting commission.
(j) Create emp table with proper constraints.
Q.2) Write a stored procedure which will accept department number and
will return total salary paid to that department. [10]
Q.3) Write a PL/SQL block which will accept name of the person and will
print name in reverse order. [10]
Q.4) Write a user defined function which will accept name of the employee
and will return job of that employee. [10]
Q.5) Write a PL/SQL block which will accept a number. If it is prime,
then user defined exception must be shown. [10]
Q.6) Write a PL/SQL block which will accept department number. Using
cursor display employee name, job and salary of employees working
in that department. [10]
Q.7) Write short notes : (Any Two) [10]
(a) Triggers
(b) Cursors
(c) Aggregate Functions
(d) Constraints

Share This
Previous Post
Next Post

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as www.IndianUniversityQuestionPapers.com . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!

0 comments:

Pen down your valuable important comments below

Search Everything Here