University of Pune 2008 Master of Computer Management (M.C.M) MCM model of Oracle - Question Paper

MCM
Oracle

Time : three Hrs. Max.Marks 70

Q.1 Write SQL queries for 20 marks

a) Create a table Player ( playerno(auto generate), name, DateOfBirth, country, flag(Batsman/Baller/All), DateOfStartOfCareer, NoOfRuns, NoOfWickets,NoOfCenturies) with constraints
b) Create a table OneDayMatch( matchno, date, playerno, Runs, Wickets,Catches,ManOfMatch)
c) Display name of player scoring countrywise highest runs
d) Display name of player and country scoring highest number of
centuries
e) Display Indian baller scoring highest runs
f) obtain the player who has started his career at the earliest age
g) Display the country names ranging from which the match was played
on 31/12/2006
h) Find who received maximum number of times the "Man Of the
Match award "
i) List the Players born in August.
j) Display the match with lowest of number of catches.

Q.2 Write a procedure which accepts deptno and prints name and salary of 1st two top salaried persons working in that department.Handle the exceptions. 10 marks
Q.3 Write a function which accepts a number and returns
whether it is prime or not. 10 marks




Q.4 Create a package with overloaded procedure raise_emp that raises salary of employees in the department. The 1st version of the procedure accepts deptno and 2nd accepts department name. 10 marks


Q.5 Write a trigger which will not allow any user to carry out any insert, update or delete transaction in other than office hours ( before 10 a.m and after six p.m) 10 marks

Q.6 Write short notes on [ Any two ] 10 marks
1) Locks 2) Cursors 3) Data kinds in Oracle

Earning:   Approval pending.