My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
|
Download Model question papers & previous years question papers
|
Posted By: Sree.... Member Level: Diamond Posted Date: 15 Mar 2008
|
2006 Andhra Pradesh State Jawaharlal Nehru Technological University B.Tech DATA BASE MANAGEMENT SYSTEMS(RR) Set No. 3 Question paper
|
|
|
Code No: RR220502 Set No. 3
II B.Tech II Semester Supplementary Examinations, Aug/Sep 2006
DATA BASE MANAGEMENT SYSTEMS
( Common to Computer Science & Engineering, Information Technology
and Computer Science & Systems Engineering)
Time: 3 hours Max Marks: 80
Answer any FIVE Questions
All Questions carry equal marks
? ? ? ? ?
1. (a) What is join ? Explain the several variants of join.
(b) Define the division operation in relational algebra. Show that it can be derived
from the primitive operations defined in the relational algebra. [10+6]
2. (a) What is a view? Explain the a views in SQL?
(b) Explain nested queries with example in SQL ? [8+8]
3. Explain clustering indices. Compare with unclustered indices. [16]
4. (a) Discuss about cost based optimization.
(b) Give a detailed account of heuristic optimization. [8+8]
5. Discuss different types of parameters that are used in cost functions. Where is this
information kept? [16]
6. (a) Define 3NF ? Explain why the employee relation in the following database
does not satisfy 3NF and decompose employee relation into relations which
do satisfy 3NF. What advantages are gained by this decomposition.
Emp.No Name Address Dept Dept Head
e1 n1 a1 d1 h1
e2 n2 a2 d1 h1
e3 n3 a3 d1 h1
e4 n4 a4 d2 h5
e5 n5 a5 d2 h5
(b) Explain the Normalization using join dependencies ? [10+6]
7. Describe each of the following locking protocols.
(a) 2PL.
(b) Strict 2PL.
(c) Conservative 2PL. [5+5+6]
8. (a) What is the difference between
i. Stable storage and disk.
ii. System crash and a media failure.
1 of 2
Code No: RR220502 Set No. 3
iii. Check points and fuzzy dumps. [3+3+4]
(b) Give a short note on crash recovery. [6]
? ? ? ? ?
2 of 2
Return to question paper search
|
|
|
Submit Previous Years University Question Papers and make money from adsense revenue sharing program
Are you preparing for a university examination? Download model question papers
and practise before you write the exam.
|
Watch TV Channels
Watch Asianet TV onlineKairali TV in InternetSurya TV onlineAmritha TV Channel
|