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

Download AKTU (Dr. A.P.J. Abdul Kalam Technical University (AKTU), formerly Uttar Pradesh Technical University (UPTU) B-Tech 6th Semester (Sixth Semester) 2016-2017 NCS069 Advance Dbms Question Paper

Printed Pageszl RollN0.I I I I I I I I I I I NCS069
B.TECH.
THEORY EXAMINATION (SEM?VI) 2016-17
ADVANCE DBMS
T ime : 3 Hours Max. Marks : 100
Note .' Be precise in your answer. In case ofnumericalproblem assume data wherever not provided.
SECTION-A
1 Explain the following : (10X2=20)
a) Transaction transparency
b) Concurrency control
0) System log
(1) Orphan and inconsistent message
e) Check point
f) Semi joins and bloom joins
g) Data Replication
h) Serializable schedules
1) Thomas write rule
j) Active databases
SECTION-B
2 Attempt any ?ve of the following : (10X5=50)
a) Discuss MOSS concurrency protocol with its architecture.
b) Explain why row level locking is generally seen more desirable than table level locking?
0) Compare the deferred? modification and immediate?modification version of the log?based recovery
schemes, in terms of ease of implementation and overhead cost.
(1) What do you understand by Database Replication Techniques? What are the parameters of Eager
Replication?
e) What is deadlock? How distributed deadlocks are handled in DDBMS?
f) What is the purpose of fragmentation in distributed database? Describe the various types of
fragmentation methods.
g) What do you mean by a lock scheduler? Explain the process of obtaining the lock. Explain the lock
table.
h) How is transaction management in distributed database different from transaction management in a
standalone database? Describe distributed transaction management.
SECTION-C
Attempt any two of the following : (15X2=30)
3 Discuss Multiple Granularity in detail using an example. Discuss the significance of Multi
Granularity in database.
4 What are protocols? Explain lock based and time stamp based concurrency protocol with
suitable example.
5 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?