Shivaji University 2005 B.E Computer Science DATABASE ENGINEERING - exam paper

H-227
THIRD YEAR OF COMPUTER SCIENCE AND ENGINEERING (PART-2) EXAMINATION, 2005
SHIVAJI UNIVERSITY, KOLHAPUR
DATABASE ENGINEERING

Day and Date: Wednesday, 23-11-2005 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) List and discuss characteristics of DBMS. [Marks 8]

b) Explain subsequent terms. [Marks 8]
a) Primary key
b) Candidate key
c) Super key

Q.2.
a) List and discuss various components of SQL. [Marks 8]

b) discuss the basic components of referential integrity. [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) Equivalence of expression
b) Database changes
c) Multiple key access
d) Graph based protocol in concurrency control

Earning:   Approval pending.