Download AKTU B-Tech 6th Sem 2016-2017 NCS067 Distributed Database Question Paper

FirstRanker.com

B.TECH.

THEORY EXAMINATION (SEM–VI) 2016-17

--- Content provided by FirstRanker.com ---

DISTRIBUTED DATABASE

Max. Marks : 100

Note: Be precise in your answer. In case of numerical problem assume data wherever not provided.

SECTION – A

1. Explain the following: 10 x 2 = 20
   1. What is a cascade less schedules?

   --- Content provided by FirstRanker.com ---

   2. State serializability. How it is tested?
   3. Differentiate strict two phase locking protocol and rigorous two phase locking protocol.
   4. What are the timestamps associated with each data item?
   5. Define replication.
   6. What is Fragmentation? Give its types.

   --- Content provided by FirstRanker.com ---

   7. Provide the Concepts in Orphan in distributed database.
   8. How database recovery can be done?
   9. What the difference is between distributed and replicated database?
   10. Define Distributed Deadlock detection.

--- Content provided by FirstRanker.com ---

SECTION – B

2. Attempt any five of the following questions: 5 x 10 = 50
   1. Compare conflict and view serializability with example.
   2. Explain timestamp based concurrency algorithms in detail.
   3. State the purpose of 2PC protocol. Explain 2PC in detail.
   4. Explain the need for the two-phase commit protocol. Then describe the two phases.

   --- Content provided by FirstRanker.com ---

   5. Illustrate the cost based query optimization for Distributed Database in detail.
   6. Mention about Recovery in Message Passing System. Explain concept of inconsistent states.
   7. What are Multiversion Schemes? Explain its importance in Multiversion Protocol.
   8. Describe query optimization algorithms.

--- Content provided by FirstRanker.com ---

SECTION - C

Attempt any two parts of the following questions:

3. 2 x 15 = 30 Explain how the transactions are managed in a distributed database. Also differentiate between Homogeneous and Heterogeneous Database.
4. Brief about Traditional recovery techniques with example.
5. What are the objects of distributed query processing? Explain.

--- Content provided by FirstRanker.com ---

For more papers visit: FirstRanker.com