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
DATABASE MANAGEMENT SYSTEM (DBMS)
(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
example.
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