Hindustan Institute of Technology and Science (HITE) 2008 B.E Computer Science and Engineering DATABASE MANAGEMENT SYSTEMS - Question Paper
Tuesday, 22 January 2013 09:15Web
DATABASE SYSTEM MANAGEMENT
PART A
1.Define Data Integrity?
2.What is a foreign key and candidate key?
3.With an example discuss weak entity in an ER diagram?
4.What are the kinds of normal forms?
5.What is a domain integrity?
6.Distinguish ranging from dense and parse indices?
7.Define B-trees?
8.What is deadlock?
9.Define distributed systems?
10.Define Data mining?
PART B
11.(a)Construct an ER diagram for Chennai constituency?
OR
(b)Explain Relational Database system?
12.(a)Explain Data Definition Language,Data Manipulation Language and Views.
OR
(b)Explain various kinds of Normal forms?
13.(a)Explain B Trees and B+ Trees?
OR
(b)Explain Indexing and Hashing techniques?
14.(a)Explain Concurrency control.
OR
(b)Explain Shadow paging and Log based recovery techniques?
15.(a)State and discuss the features of object oriented data model.Use banking application as an example?
OR
(b)Explain distributed database and Data warehousing?
a different kind of questions:
PART A
1.What are the advantages of file processing systems?
2.What is logical schema?
3.Define query language?
4.What is functional dependency?
5.What are the kinds of primary Index?
6.Define B trees?
7.What is query processing?
8.What is the benefit of strict 2 phase locking?
9.Define Data Mining?
10.What is an active database?
PART B
11.(a)Explain Data Warehousing and Data Mining?
OR
(b)Explain Object oriented database?
12.(a) discuss structure of XML?
OR
(b)Compare File systems with the Database systems?
(c)Explain schema?
13.(a)Explain ER model with suitable example?
OR
(b)Explain Relational algebra?
14.(a) discuss Normalization?
OR
(b)Explain Queries in SQL?
(c)Explain Integrity and Security?
15.(a)Explain concurrency control in transaction management?
(a)Explain Recovery techniques?
OR
(c)Explain B trees and B+ trees?
(d)Explain Query Processing?
Earning: Approval pending. |