University Of Pune Question Paper
M. C. M. (Semester - II) Examination - 2012
ORACLE
(New 2008 Pattern)
Time : 3 Hours] [Max. Marks : 70
Instructions :
(1) All questions are compulsory.
(2) Figure to the right indicate full marks.
(3) Write your assumptions clearly.
Q.l) Consider the following table to solve the following queries : (Any Ten) [20]
Emp (eno, e_name, dob, gender, sal, deptno, designo, address, city,
date_of_join)
Dept (deptno, dept_name, loc)
Designation (designo, design_name, min_qualification)
(1) Create Emp table with constraints.
(2) Display department wise maximum salary.
(3) Display the total number of male employees in each department.
(4) Display list of employees whose name begins with 'H' and ends
with ‘I’.
(5) Display list of employees whose designation is 'clerk'.
(6) Display the employee details along with dept name.
(7) Display the list of employees who born in the month of 'January'.
(8) Display the list of all employees whose working location is 'Pune'.
(9) Display the list of all employees whether they have allotted dept
or not.
[(10) Display the list of employees who joined the company in the
year '2007'.
(11) Display list of employees whose salary is in between 15000 and
30000.
Q.2) Explain Oracle Architecture in detail. [10]
Q.3) Write differences between following : (Any Three) [09]
(a) LTRIM and RTRIM
(b) Drop and Truncate
(c) Ceiling and Floor
(d) Primary Key and Unique Key
Q.4) Write short notes : (Any Four) [16]
(a) Set Operators
(b) Views
(c) Locks in Oracle
(d) Aggregate Functions
(e) Report Writing Commands in SQL*PLUS
Q.5) Solve the following PL/SQL Programs : (Any Three) [15]
(a) Write a PL/SQL block to print an accepted string in reverse ?
(b) Write a DML trigger for STUD which will keep track of all
operation type and operation date and user name in an
AUDIT_STUD Table.
(c) Write a cursor which will display top 5 salaried employees.
(d) Write a PL/SQL Program to accept a number and print its sum
of digits.
M. C. M. (Semester - II) Examination - 2012
ORACLE
(New 2008 Pattern)
Time : 3 Hours] [Max. Marks : 70
Instructions :
(1) All questions are compulsory.
(2) Figure to the right indicate full marks.
(3) Write your assumptions clearly.
Q.l) Consider the following table to solve the following queries : (Any Ten) [20]
Emp (eno, e_name, dob, gender, sal, deptno, designo, address, city,
date_of_join)
Dept (deptno, dept_name, loc)
Designation (designo, design_name, min_qualification)
(1) Create Emp table with constraints.
(2) Display department wise maximum salary.
(3) Display the total number of male employees in each department.
(4) Display list of employees whose name begins with 'H' and ends
with ‘I’.
(5) Display list of employees whose designation is 'clerk'.
(6) Display the employee details along with dept name.
(7) Display the list of employees who born in the month of 'January'.
(8) Display the list of all employees whose working location is 'Pune'.
(9) Display the list of all employees whether they have allotted dept
or not.
[(10) Display the list of employees who joined the company in the
year '2007'.
(11) Display list of employees whose salary is in between 15000 and
30000.
Q.2) Explain Oracle Architecture in detail. [10]
Q.3) Write differences between following : (Any Three) [09]
(a) LTRIM and RTRIM
(b) Drop and Truncate
(c) Ceiling and Floor
(d) Primary Key and Unique Key
Q.4) Write short notes : (Any Four) [16]
(a) Set Operators
(b) Views
(c) Locks in Oracle
(d) Aggregate Functions
(e) Report Writing Commands in SQL*PLUS
Q.5) Solve the following PL/SQL Programs : (Any Three) [15]
(a) Write a PL/SQL block to print an accepted string in reverse ?
(b) Write a DML trigger for STUD which will keep track of all
operation type and operation date and user name in an
AUDIT_STUD Table.
(c) Write a cursor which will display top 5 salaried employees.
(d) Write a PL/SQL Program to accept a number and print its sum
of digits.
0 comments:
Pen down your valuable important comments below