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: 02 Dec 2008 Posted By: prakash Member Level: Gold
|
2006 Jawaharlal Nehru Technological University Computer Science & Engineering IV B.Tech II Semester Regular Examinations, Apr/May 2006 ADVANCED DATABASES Question paper
Code No: RR421501 Set No. 4
IV B.Tech II Semester Regular Examinations, Apr/May 2006
ADVANCED DATABASES
(Computer Science & Systems Engineering)
Time: 3 hours Max Marks: 80
Answer any FIVE Questions
All Questions carry equal marks
? ? ? ? ?
1. Give an overview of distributed databases. [16]
2. Discuss a read-only application at the following levels of distribution transparency.
(a) Fragmentation transparency.
(b) Location transparency.
(c) Local mapping transparency. [5+5+6]
3. Explain about primary fragmentation and derived horizontal fragmentation.[16] s
4. What is operator graph Illustrate with an example how common sub expressions
are determined. [16]
5. Explain the simpler representation of queries and a model for query Optimization.
[16]
6. Define the terms: atomicity, consistency, isolation, durability, schedule, blind write,
dirty read, unrepeatable read, recoverable schedule, avoids-cascading aborts sched-
ule. [16]
7. (a) Explain the conservative time stamp method.
(b) Explain the primitive and non-primitive methods for deadlock prevention.
[16]
8. (a) Describe with examples, the types of problems that can occur in distributed
transactions environment when concurrent access to the database is allowed.
(b) Give the details of a mechanism for concurrency control that can be used to
ensure that the types of problems discussed above cannot occur.
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
|