JNTU Previous Question Papers B Tech III Database Management System June 2007
1. (a) What is a Data model ? List the important data models
iii. Data sublanguage
iv. Host language
2. (a) what are the various salient features of the QBE ?
(b) Explain the following :
i. Relational database query.
ii. Query language
iv. Embedded SQL.
3. (a) Discuss the mechanism used to read data from or write data into the disk.
(b) Explain how the double buffering improves the block access time.
4. What is
(a) query− evaluation plan
(b) query− execution engine
(c) catalog information about relations and indices
5. Discuss in detail about estimating the cost of an evaluation plan for a query block.
6. (a) The following set of functional dependencies for relation scheme R=(A.B,C,D,E)
A− > BC
CD− > E
B− > D
E− > A
Using the functional dependencies. Compute the canonical cover Fc .
(b) Explain the concept of aggregation and specialization with examples.
7. (a) Discuss about deadlock detection and starvation.
(b) Explain read-only and write-only protocols and read-before-write protocol in Serializability.
8. Explain WAL Protocol, UNDO algorithm, Check pointing and Media Recovery?