Download AKTU B-Tech 6th Sem 2016-2017 NCS069 Advance Dbms Question Paper

FirstRanker.com

Roll No.

B.TECH.

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

THEORY EXAMINATION (SEM–VI) 2016-17

ADVANCE DBMS

Time: 3 Hours

Max. Marks : 100

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

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

SECTION-A

1. Explain the following : (10×2=20)
   1. Transaction transparency
   2. Concurrency control
   3. System log
   4. Orphan and inconsistent message

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

   5. Check point
   6. Semi joins and bloom joins
   7. Data Replication
   8. Serializable schedules
   9. Thomas write rule

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

   10. Active databases

SECTION-B

2. Attempt any five of the following : (10×5=50)
   1. Discuss MOSS concurrency protocol with its architecture.
   2. Explain why row level locking is generally seen more desirable than table level locking?

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

   3. Compare the deferred- modification and immediate-modification version of the log-based recovery schemes, in terms of ease of implementation and overhead cost.
   4. What do you understand by Database Replication Techniques? What are the parameters of Eager Replication?
   5. What is deadlock? How distributed deadlocks are handled in DDBMS?
   6. What is the purpose of fragmentation in a database? Describe the various types of fragmentation methods.
   7. What do you mean by a lock scheduler? Explain the process of obtaining the lock. Explain the lock table.

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

   8. How is transaction management in distributed database different from transaction management in a standalone database? Describe distributed transaction management.

SECTION-C

3. Attempt any two of the following : (15×2=30)
   1. Discuss Multiple Granularity in detail using an example. Discuss the significance of Multi Granularity in database.
   2. What are protocols? Explain lock based and time stamp based concurrency protocol with suitable example.

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

   3. Differentiate between RDBMS and OODBMS. How does the concept of an object in the object oriented model differ from the concept of the entity in the entity-relationship model?

FirstRanker.com