Questions Search

This website covers previous years question papers of various universities and colleges in India. Moreover, the information on admission to various courses from various universities/institutes/colleges are also available. Also the latest teaching faculty plus teachers jobs, Government jobs, Banking Jobs, and other jobs are regularly updated to help jobless candidates. Admit cards of various recruitment of Govt organisation are updated. Search your terms using the search box provided.

Follow by Email

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

No comments:

Post a Comment

Pen down your valuable important comments below