Post Graduate Diploma- Post Graduate Diploma In Computer Applications (PGDCA) 3rd Sem 302 : ORACLE(University of Pune, Pune-2013)
P.G.D.C.A. (Semester – III) Examination, 2013
302 : ORACLE
(2008 Pattern)
Time : 3 Hours Max. Marks : 70
Instructions :
1) Q. 1 and Q. 5 are compulsory.
2) Solve any two questions from the remaining.
3) Figures to the right indicate full marks.
1. Consider 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 employee information of people staying in Pune city.
b) List employee name, job and salary of employees in department no. 10.
c) Display all employees joined the organization in the month of December.
d) Display name of the department having highest no. of employee.
e) Display clerks having salary more than 3000.
f) Display department wise sorted employee list.
g) List employees working in “Accounts” department.
h) Display name of the person getting highest salary.
i) Display name of the employees not getting commission.
j) Write command to create table emp with proper constraints.
2. a) Write PL/SQL block which will accept a number and print whether that number is odd or even. 10
b) Explain use of Select statement. 10
3. a) Explain a stored procedure which will accept empno as parameter and will return his salary. 10
b) Write a user defined function which will return name of the president of that organization. 10
4. a) Explain with suitable example exception handling. 10
b) Explain how sub queries are used with examples ? 10
5. Write short notes (any two) : 10
a) Update statement
b) Data types
c) Aggregate functions
d) Constraints.
| Earning: ₹ 7.05/- |
