University Of Pune Question Paper
M. C. M. (Semester - II) Examination - 2010
ORACLE
(Old 2005 Pattern)
Time : 3 Hours] [Max. Marks : 70
Instructions :
(1) Question Nos. 1 and 6 are compulsory.
(2) Solve any three from the remaining.
Q.1) Consider the following tables :
(1) Policyholder (Policy No, Policyholder_NM, Policy_Desc,
Policy_Yrs, No. of Premium, Premium_Type)
Premium_type : ‘Q’ - Quarterly, ‘M’ - Monthly, ‘H’ - Halfyearly
‘Y’ - Yearly.
(2) Premium (Policy No., Premium Paid_Dt, Premium_Amt,
Premium_Paid_Status)
(A) Create above tables with suitable constraints. [08]
(B) Solve the following : (Any Six) [6x2=12]
(a) Allow user to input values from keyboard and insert it into
table as record.
(b) Create view with Policy No, Polciyhodler_NM, Premium
Paid Date, Premium Amount.
(c) Create Indices for above tables.
(d) Write a command to generate value for policy number for
every policyholder record.
(e) Display all Policyholders, whose premiums are not paid.
(f) Add new column ‘premium_paid_type’ in premium table.
Premium paid types are cash, cheque, internet.
(g) Display all policyholder details, who pay premium by
Internet facility.
Q.2) What is Cursor ? Write Implicit Cursor using any of the above tables. [10]
Q.3) Write PL/SQL, which will raise an exception for No Data Found.
(Use table from Q.1) [10]
Q.4) Explain user defined function, with suitable example.
(Use tables from Q.1) [10]
Q.5) Explain Package with its proper syntax. Give suitable example. [10]
Q.6) Short notes : (Any Four) [4x5=20]
(a) Five Attributes for Report Writing (SQL)
(b) Set Operators
(c) Constraints
(d) Exception Handling
(e) Commit, Roll Back, Save Point
M. C. M. (Semester - II) Examination - 2010
ORACLE
(Old 2005 Pattern)
Time : 3 Hours] [Max. Marks : 70
Instructions :
(1) Question Nos. 1 and 6 are compulsory.
(2) Solve any three from the remaining.
Q.1) Consider the following tables :
(1) Policyholder (Policy No, Policyholder_NM, Policy_Desc,
Policy_Yrs, No. of Premium, Premium_Type)
Premium_type : ‘Q’ - Quarterly, ‘M’ - Monthly, ‘H’ - Halfyearly
‘Y’ - Yearly.
(2) Premium (Policy No., Premium Paid_Dt, Premium_Amt,
Premium_Paid_Status)
(A) Create above tables with suitable constraints. [08]
(B) Solve the following : (Any Six) [6x2=12]
(a) Allow user to input values from keyboard and insert it into
table as record.
(b) Create view with Policy No, Polciyhodler_NM, Premium
Paid Date, Premium Amount.
(c) Create Indices for above tables.
(d) Write a command to generate value for policy number for
every policyholder record.
(e) Display all Policyholders, whose premiums are not paid.
(f) Add new column ‘premium_paid_type’ in premium table.
Premium paid types are cash, cheque, internet.
(g) Display all policyholder details, who pay premium by
Internet facility.
Q.2) What is Cursor ? Write Implicit Cursor using any of the above tables. [10]
Q.3) Write PL/SQL, which will raise an exception for No Data Found.
(Use table from Q.1) [10]
Q.4) Explain user defined function, with suitable example.
(Use tables from Q.1) [10]
Q.5) Explain Package with its proper syntax. Give suitable example. [10]
Q.6) Short notes : (Any Four) [4x5=20]
(a) Five Attributes for Report Writing (SQL)
(b) Set Operators
(c) Constraints
(d) Exception Handling
(e) Commit, Roll Back, Save Point
0 comments:
Pen down your valuable important comments below