New Member FAQ | Forums | Earn Revenue


Resources Entrance Ask Experts Exam Papers Jobs English Projects Universities Colleges Courses Schools Training My India



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.

website counter



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



Course: B.Tech Computer Science & Engineering   University: Jawaharlal Nehru Technological University




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

Next Question Paper: IV B.Tech II Semester Regular Examinations, Apr/May 2006 ADVANCED DATABASES

Previous Question Paper: IV B.Tech II Semester Regular Examinations, Apr/May 2006 HOSPITAL SYSTEMS MANAGEMENT

Related Question Papers:


  • IV B.Tech II Semester Supplementary Examinations, April/May 2006 REAL TIME CONTROL OF POWER SYSTEMS


  • Code No: R05 III B.Tech I Semester Regular Examinations, November 2008 POWER ELECTRONICS


  • II B.Tech I Semester Supplementary Examinations, May 2005 ELECTRICAL TECHNOLOGY


  • jntu


  • IV B.Tech. II Semester Supplementary Examinations, July -2005 DIGITAL SPEECH & IMAGE PROCESSING


  • Categories


    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





    Contact Us   Advertise   Editors    Privacy Policy    Terms Of Use   

    ISC Technologies.
    2006 - 2009 All Rights Reserved.