JNTU Previous Question Papers B Tech III Database Management System June 2007

 B.Tech III Semester June 2007

DATA BASE MANAGEMENT SYSTEMS

SET-III

1. (a) What is a Data model ? List the important data models

(b) Explain

i. DDL

ii. DML

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

iii. SQL

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) queryevaluation plan

(b) queryexecution 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?

Leave a Comment