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 Date: 01 Oct 2008 Posted By: Sriram Member Level: Diamond
|
2008 Andhra Pradesh State Jawaharlal Nehru Technological University B.Tech DATA BASE MANAGEMENT SYSTEMS Set No. 4 Question paper
Code No: RR420207 Set No. 4
IV B.Tech II Semester Regular Examinations, Apr/May 2008
DATA BASE MANAGEMENT SYSTEMS
(Electrical & Electronic 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) Explain with an example about Aggregate functions and grouping in SQL.
[5+3=8]
(b) Assume the following relations:
STUDENT (Stname, Stnum, Totalmarks, Semester)
HOSTEL (Stnum, Roomnum)
Represent the following queries in SQL.
i. Get the details of 6th semester students
ii. Obtain the room number allotted to Girish
iii. Obtain the names of students staying in room number 24.
iv. Get the name and marks of student whose number is 24046 [2+2+2+2]
3. (a) Write a note on secondary indexes.
(b) Write a note on sparse and dense indexes. [8+8]
4. (a) Explain external sort - merge algorithm.
(b) Discuss about estimation of the size of joins. [10+6]
5. (a) Write short notes on
- cost-based optimization
- heuristic optimization
(b) Detail on the structure of query optimization. [5+5+6]
6. (a) Let R=(A,B,C,D,E) and letMbe the following set of multivalued dependencies
A- >> BC
B- >> CD
E- >> AD
List the nontrivial dependencies in M+
(b) Describe the properties of normalized and unnormalized relations. [10+6]
7. (a) Explain Binary locks, Shared Locks and Exclusive locks ?
(b) What is the two phase locking protocal? How does is guarantee serializability.
[6+10]
1 of 2
Code No: RR420207 Set No. 4
8. (a) When a system recovers from a crash ? In what order must transaction be
Undone and Redone? Why is this order important?
(b) What is a log in the content of DBMS? How does check pointing eliminate
some of the problems associated with log based recovery? [8+8]
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.
|
Advertise Here
|