Jawaharlal Nehru Technological University Kakinada 2010 B.Tech Computer Science and Engineering DBMS of --SET 3 - Question Paper

CODE No: V0523/R07 Set No. 3
II B.Tech II Semester Regular Examinations, April 2010
DATA BASE MANAGEMENT SYSTEMS
( Common to Computer Science & Engineering and info
Technology)
Time: three hours Max Marks: 80
ans any 5 ques.
All ques. carry equal marks

1. elaborate the major disadvantages of file processing system? [16]
2. (a) What is a relation? Differentiate ranging from relation schema and relation in-
stance. describe the terms unity and degree of relation. elaborate domain
constraints?
(b) What SQL construct enables the definition of a relation? What constructs
allow modification of relation instances? [8+8]
3. (a) discuss in detail about the "Outer join" Operation.
(b) For the subsequent relational database, provide the expressions in SQL. [8+8]
Sailor schema (sailor id, sailorname, rating, Age) Reserves (sailor id, Boat)id,
day) Boat Schema(Boat id, boatname, color)
i. obtain the name and age of the oldest sailors?
ii. Count the No.of sailors?
iii. Count the No.of various sailors names?
iv. obtain the names who are older than the oldest sailors with rating of 10?
4. discuss the FD and MVD with examples? [16]
5. (a) describe the concept of schedule for a set of concurrent transaction. provide a
suitable example. [8]
(b) discuss read-only, write-only & read-before-write protocols in serialazability.
[8]
6. (a) elaborate the 2 tables used in crash recovery along with log record. discuss
with suitable example. [8]
(b) elaborate the various fields of log record. discuss every in brief. [8]
7. describe the term dangling pointer. define how the unique-id scheme helps in
detecting dangling pointers in an object-oriented database. [16]
8. discuss about the B+
-tree and the structure of B+
-tree in detail with an example.[16]

Earning:   Approval pending.