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

Pellentesque vitae lectus in mauris sollicitudin ornare sit amet eget ligula. Donec pharetra, arcu eu consectetur semper, est nulla sodales risus, vel efficitur orci justo quis tellus. Phasellus sit amet est pharetra


Pen down your valuable important comments below