Dr Bhim Rao Ambedkar University 2006 B.Tech Information Technology Database Engineering - university paper
Sunday, 20 January 2013 03:20Web
Y-571
THIRD YEAR OF COMPUTER SCIENCE AND ENGINEERING (PART-2) EXAMINATION, 2006
DATABASE ENGINEERING
Total Marks: 100
Time: 10.00p.m. To 1.00p.m.
Instructions:
Instructions:
1) Solve any 3 ques. from SECTION-1
2) Solve any 3 ques. from SECTION-2
3) Figures to right shows full marks
SECTION-1
Q.1
a) Explain entities their sets and aping constraints. [Marks 8]
b) Discuss the concept overgeneralization and aggression. [Marks 8]
Q.2.
a) Illustrate with example the relational algebra. [Marks 8]
b) What is SQL? explain salient features of SQL. [Marks 8]
Q.3
a) Describe typical RDBMS. [Marks 8]
b) How does the remapping of bad sectors by disc controllers affect data retrieval rates? discuss in brief. [Marks 8]
Q.4 Write a short notes on (any 3) [Marks 18]
a) Data abstraction model
b) Domain relational calculus
c) Attributes kinds in ER diagram
d) Buffer management
SECTION-2
Q. 6)
a) define the basic concept of indexes. [Marks 8]
b) Draw state diagram of transaction. discuss in brief [Marks 8]
Q.6)
a) Describe database log-in log based recovery. [Marks 8]
b) define conflicts serilizable schedules [Marks 8]
Q.7)
a) Explain testing of view serilizability. [Marks 8]
b) Explain transaction in detail. [Marks 8]
Q.8) Write a short notes on (any three): [Marks 18]
a) Two phase locking protocol
b) Stable storage implementation
c) Check-point
d) Graph based protocol in concurrency control
Earning: Approval pending. |