Questions Search

This website covers previous years question papers of various universities and colleges in India. Moreover, the information on admission to various courses from various universities/institutes/colleges are also available. Research paper questions are also updated from time to time. Also the latest teaching faculty plus teachers jobs, Government jobs, Banking Jobs, and other jobs are regularly updated to help jobless candidates. Admit cards of various recruitment of Govt organisation are updated. Search your terms using the sejavascript:void(0)arch box provided.
Are you student / faculty of Vikram University Ujjain? We are collecting old question papers. If you have latest question papers 2016 / 2015 / 2014 years, then contact us through email [email protected] / [email protected] . We will give you money for your question papers you send to us.

TNPSC Group IV 2016 Model Questions AnswersTNPSC Group IV

Anna Univ B.E Civil Engineering Previous Years Question PapersBE Civil Anna Univ

Anna Univ B.E EEE Previous Years Question PapersB.E EEE Anna Univ Questions

Anna Univ B.E Mechanical Engineering Previous Years Question PapersMechanical B.E Questions

Anna Univ B.E CSE Previous Years Question PapersMechanical B.E Questions

Anna Univ B.E ECE Previous Years Question PapersMechanical B.E Questions

VTU Question PapersLatest News

Dharmsinh Desai University Previous Years Question PapersLatest News

NEW: Last 05+ Years Question Papers of CE6451 Fluid Mechanics and Machinery

NEW: ME6502 Heat and Mass Transfer AU Chennai Last 10 Set of Question Papers

NEW: CE2027 Housing Planning and Management 2014 Question Paper

Himachal Pradesh University (HPU) Previous Years Question Papers

ME2027 PPCE All Previous Years Question Papers [NEW]

GNDU Previous Years Question Papers [NEW]

Teachers TGT, PGT, PRT jobs in New Delhi Schools

GATE 2016 JANUARY

Follow by Email

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

No comments:

Post a Comment

Pen down your valuable important comments below