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: 06 Feb 2008
|
2006 Andhra Pradesh State Jawaharlal Nehru Technological University B.Tech ADVANCED DATABASES Question paper
|
|
|
Code No: NR420504 NR
IV B.Tech II Semester Supplementary Examinations, Apr/May 2006
ADVANCED DATABASES
( Common to Computer Science & Engineering and Computer Science &
Systems Engineering)
Time: 3 hours Max Marks: 80
Answer any FIVE Questions
All Questions carry equal marks
? ? ? ? ?
1. Explain ISO/OSI reference Architecture. [16]
2. Consider the global relations: PATIENT (NUMBER, NAME, SSN, AMOUNT-
DUE, DEPT, DOCTOR, MED-TREATMENT) DEPARTMENT (DEPT, LOCA-
TION, DIRECTOR) STAFF(STAFFNUM, DIRECTOR, TASK) Define their frag-
mentation as follows
(a) DEPARTMENT has a horizontal fragmentation by LOCATION, with two
locations: Each department is conducted by one DIRECTOR.
(b) There are several staff members for each department, led by the departments
director, STAFF has a horizontal fragmentation derived from that of DE-
PARTMENT and a semi-joint on the DIRECTOR attribute. Which assump-
tion is required in order to assure completeness and disjointness? Give also
the reconstruction of global relations from fragments. [8+8]
3. (a) Distinguish between non-redundant and redundant allocation.
(b) Write briefly on the Measure of Costs and Benefits of Fragment Allocation.
[16]
4. What is parametric query. Give an example. Describe cut operation with respect
to the example. [3+3+10]
5. Discuss about the Query optimization using SDD-1 algorithm. [16]
6. (a) What are the goals of transaction management.
(b) Define:
i. Atomicity.
ii. Durability.
iii. Serializability.
iv. Isolation. [4+12]
7. (a) Explain centralized controller methods for deadlock detection. List out the
drawbacks.
(b) Explain hierarchical controller method for deadlock detection. [10+6]
8. (a) Explain the operation of two-phase commitment protocol at the time when al
sites are inactive.
1 of 2
Code No: NR420504 NR
(b) Explain the features of primary copy locking approach. [10+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
|