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. 4 Question paper
|
|
|
Code No: RR220502 Set No. 4
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) Define the following with suitable examples:
i. Relation
ii. Cardinality of a relation
iii. Super-key
iv. Candidate key. [2+2+2+3]
(b) Explain the structure of relational model. [7]
2. Explain the various types of aggregate functions with suitable examples in SQL.
[16]
3. (a) Write a note on dense and sparse indexing.
(b) Write a note on fixed and variable length records. [8+8]
4. (a) Explain what role does statistics gathered from the database play in query
optimization?
(b) What are the important design decisions that must be made in optimizing the
relational queries? [6+10]
5. Show that the following equivalences hold and explain how they can be applied to
improve the efficiency of certain updates.
(a) s
p(r1 [ r2) = s
p(r1) [ s
p(r2)
(b) s
p(r1 - r2) = s
p(r1) - s
p(r2) [8+8]
6. (a) Explain why 4NF is more desirable Normal Form than BCNF.
(b) Consider the relation R(A,B,C,D,E) and FD’s
A- > BC
C- > A
D- > E
F- > A
E- > D
Is the Decomposition R in to R1(A,C,D) , R2(B,C,D) and R3(E,F,D) loss
less? Explain the requirement of lossless decomposition. [8+8]
7. (a) Explain Two phase locking with algorithms.
1 of 2
Code No: RR220502 Set No. 4
(b) What is Transaction? In what ways is it different from an ordinary program
(Like ’C’). [10+6]
8. Explain in detail the ARIES recovery method. [16]
? ? ? ? ?
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
|