Friday, December 18, 2015

(C) D.B.M.S. WITH ORACLE (SPECIALIZATION - I),University Of Pune Question Paper,2010 Question Paper,P. G. D. B. M. (Semester - IV)

University Of Pune Question Paper
P. G. D. B. M. (Semester - IV) Examination - 2010
(New 2008 Pattern)
Time : 3 Hours] [Max. Marks : 70
Instructions :
(1) Q. Nos. 1 and 5 are compulsory.
(2) Solve any two questions from the remaining.
(3) Figures to the right indicate full marks.
Q.1) Consider the following table structure to write SQL queries : [20]
Patient Table :
pno number(3), pname varchar2(30), billamt number(4), disease
varchar2(10), doctorno number(2), address varchar2(30), admitdate
Date, discharge_date Date.
Doctor Table :
doctorno number(2), dname varchar2(30), specialization varchar2(30)
PatientDoctor Table :
pno number(3), doctorno number(2)
(1) List all patients from Pune City.
(2) List all patients having ‘R’ as third character in their names.
(3) Show alphabetical list of patients admitted on 20 August, 2009.
(4) Show all doctors working for cancer patients.
(5) Display names of doctors attending maximum patients.
(6) Display how many days patients were admitted in the hospital ?
(7) Show which doctor has not attended any patient ?
(8) Create patient table with proper constraints.
(9) Insert a record in patient table.
(10) Show patient name who has paid maximum bill amount.
Q.2) (A) Write PL/SQL block which will accept a number and print table
of that number. [10]
(B) Explain Alter Statement. [10]
Q.3) (A) Explain E.F. Codd’s Rules. [10]
(B) Write a user defined function which will accept patient name
and will return admit date of that patient. [10]
Q.4) (A) Explain Oracle Architecture. [10]
(B) Explain characteristics of DBMS. [10]
Q.5) Write short notes : (Any Two) [10]
(a) Select Statement
(b) Data Types
(c) Aggregate Functions
(d) Constraints
Share This
Previous Post
Next Post

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!


Pen down your valuable important comments below