Hindustan Institute of Technology and Science (HITE) 2009 B.E Computer Science University - exam paper

DATABASE MANAGEMENT SYSTEM
PART A:

1.Define transaction?
2.What are horizontal and vertical fragmentation?
3.What benefit is given by strict-two phase locking?
4.Briefly write the overall process of data warehousing?
5.Define homogeneous and heterogeneous?
6.Give the meaning of expression of ACID transaction?
7.When the 2 schedule conflicts equivalent?
8.Define the term fragmentation and replication,in terms of data storage?
9.What are structured datatypes?What are collection datatypes?
10.What is distributed database?

PART B(Answer any five)

1.Explain Data Mining and Data warehousing?
2.Explain the structure of XML with example?
3.(a)Explain Timestamp-based concurrency control protocol and the modification implemented in it?
(b)Describe shadow paging recovery techniques?
4.(a)Explain two-phase locking protocol?
(b)Explain log based recovery technique?
5.(a)Highlight the features of object oriented database?
(b)Describe X path and X query with an example?
6.(a)What is deadlock prevention and detection method?
(b)Explain deadlock recovery techniques?
7.Explain concurrency protocol.How it is implemented in database management?

Earning:   Approval pending.