Hindustan Institute of Technology and Science (HITE) 2009 B.E Computer Science DATABASE MANAGEMENT SYSTEMS - Question Paper

DATABASE MANAGEMENT SYSTEMS

PART A:
1.Define data dependence?
2.Difference ranging from Database and file system.
3.Define relational database?
4.Distinguish ranging from primary key and candidate key?
5.Define query language?
6.What is domain constraint?
7. Distinguish dense and sparse indices?
8.Define deadlock and their necessary conditions to occur?
9.What is active database and their advantages?
10.Define Data warehousing and Data mining?

PART B:
11.(a)Explain Relational database design?
(b)Explain Entity relationship with an example?
OR
(c)Explain the role and function of database administrator.
(d)Discuss DMl and DDL commands?
12.(a)Explain normalization and their kinds in detail?
(b)Explain file structure and storage?
OR
(c)Explain structure of XML with an example?
(d)Explain Indexing and hashing techniques in detail?
13.(a)Explain Query Optimization in detail?
(b)Explain Concurrency control in detail with example?
OR
(c)How to recover a record in the database using recovery techniques?
(d)Deadlock prevention and handling in detail?
14.Database System Architecture in detail?
OR
discuss Distributed and parallel database in detail?
15.Explain Data warehousing and data mining in detail?
OR
(a)State and discuss the features of object oriented data model.Use banking application as an example.
(b)Explain the subsequent in detail Btree and B+ tree?

Earning:   Approval pending.