Friday, December 18, 2015

University Of Pune Question Paper,2010 Question Paper,P. G. D. C. A. (Semester - II),DATABASE MANAGEMENT SYSTEM (DBMS)

University Of Pune Question Paper
P. G. D. C. A. (Semester - II) Examination - 2010
(Old 2005 Pattern)
Time : 3 Hours] [Max. Marks : 80
Instructions :
(1) Question No. 1 is compulsory.
(2) Solve any four from the remaining.
(3) All questions carry equal marks.
Q.1) Consider the following table structure to write SQL queries :
Item Table :
itemno number(3), iname varchar2(30), stock number(4),
min_level number(3), reorder_level number(3), reorder_qty number(3).
Supplier Table :
suppno number(2), sname varchar2(30), saddress varchar2(30).
Item Supplier Table :
itemno number(3), suppno number(2), rate number(7).
(a) List all suppliers from Pune City.
(b) List all items having stock = 100.
(c) Show alphabetical list of suppliers.
(d) Show all suppliers names and rate for “washing machines”.
(e) Display names of items starting with letter “s”.
(f) Create item table with proper constraints.
(g) Insert a record in supplier table.
(h) Delete record from item table if stock is zero.
Q.2) (A) Discuss advantages and limitations of DBMS.
(B) What is Anomaly ? Explain different types of Anomalies with
Q.3) (A) Explain concept, properties, state of transaction.
(B) Compare HDM, NDM and RDM.
Q.4) (A) Distinguish between Generalisation and Specialisation.
(B) Explain Log Based Recovery.
Q.5) Explain E.F. Codd’s Rules.
Q.6) Write short notes : (Any Two)
(a) Keys in DBMS
(b) Mapping Cardinalities
(c) Aggregation
(d) Shadow Paging
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