CS-06 Data Base Management System June-2001
Question Paper of CS-06 Data Base Management System June-2001
Q.l(a). Name the major advantages of a Database Management System (DBMS) over a File Management System.
(b) Define the following concepts in the context of DBMS:
(i) Bit Map
(ii) Candidate Key
(iii) Referential integrity
© What does VSAM stand for ? Briefly describe VSAM.
(d) Discuss briefly the possible problem with an unnormalized database.
(e)We are given the following record-types (relation types):
Express the following commands in SQL:
(i) Get P# for the parts for which weight of the part is 5 kg and colour is black,
(ii) Give the details of all suppliers from the city of Bombay and turnover of more than Rs. 50 lacs.
(f) Compare object oriented and Relational approaches to Database design.
(g) Explain briefly what do you understand by Distributed computing environment.
This also includes the following :
1. Global Dictionary
2. Two Phase Commit (2Pc)
3. Replicated Server/Table