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

Code No: V0523/R07 Set No. 4
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. (a) discuss the Transaction management in a database.
(b) explain the Query Processor of Database system structure. [8+8]
2. (a) Distinguish ranging from procedural and non-procedural DML's.
(b) describe relational algebra, Tuple & Domain relational calculus.
(c) elaborate the differences ranging from the 2 kinds of relational calculus? [6+6+4]
3. (a) describe selection and also discuss complex selection.
(b) for the subsequent relational database write the expressions in SQL. [6+10]
flight (flight no, from, to, distance, departs arrives, price)
Aircraft (Aid, Aircraftname, cruising range)
Certified (Emp cd, Aid)
Employee (Emp id, Empname, salary)
i. obtain the names of pilot whose salary are individually less than price of
the cheapest route from ?Los Angles? to Honolulu ?
ii. Print the enames of pilots who can operate planes with cursing range
greater than 5000 miles, but r not certified on any boxing aircraft?
iii. obtain the names of pilots certified for a few Boeing aircraft?
iv. obtain the aids of all aircraft that can be used on routes Los Angles to
Chicago?
v. calculate the difference b/n the avg. salary of a pilot and the avg.
salary of all employees?
4. (a) discuss about four Nf? provide 1 example?
(b) discuss about five Nf? provide 1 example? [8+8]
5. (a) discuss how concurrency execution of transactions improves overall system
performance. [8]
(b) elaborate the transaction isolation Levels in SQL. [8]
6. (a) What is 2PL Locking protocol? discuss with suitable example? How does it
guarantee serialazability? [12]
(b) Difference ranging from Strict 2PL & Rigorous 2PL [4]
7. List the physical storage media available on the computers youu use routinely. provide
the speed with which data can be accessed on every mediaum.
8. (a) discuss about Hash indices with an example.
(b) discuss the differences ranging from Static Hashing and Dynamic Hashing. [8+8]

Earning:   Approval pending.