Printed Pages-2

ECSO76

Following Paper ID and Roll No. to be filled in yourAnswer Book

B. Tech. (sEM. Vrr) THEORY EXAMTNATTON- 20t1 -12

DISTRIBUTED DATABASE Time

: 3 Hours

Total Marks

:

100

Note :- Attempt all questions.

l.

Attempt any two parts of the following

(a)

(10x2=20)

:

Explain popular applications of databases. Compare distributed database with centralized databases.

(b)

Explain the methods for concurrency control in distributed transactions.

(c)

Explain conflict and view serializability with example. Also

differentiate between them.

L 2.

Attempt any two parts of the following

(a) What do you mean by two-phase

it

is

Explain Lock based protocol in detail. What is the role

of

different from strict 2-phase locking

(b)

(10x2=20)

:

locking ? How ?

time stamp based protocol in Locking

(c)

Explain briefly.

?

Describe architecture for locking schedular.

ECS076/KIH-26391

fTurn Over

3.

Attempt any two parts of the following

(a)

:

(10x2=20)

Explain Flat and Nested Distributed Transaction with suitable example.

(b)

What is Replication

?

Explain importanttypes ofreplication

Techniques.

(c)

Write short notes on

(i)

:

Fragmentation

(ii)

Distributed commit/abort

conditions.

4.

Attempt any two parts of the following

(a)

:

(10x2=20I*

Explain Issues ofRecovery in distributed database. Explain types of failure in distributed system.

(b)

What is check point based Recovery

?

Give the advantages

and disadvantages ofdifferent types ofcheck point based recovery method.

(c)

What is Recovery in Message Passing Systems

?

Explain

concept of inconsistent states.

5.

Attempt any two parts of the following

(a)

:

(10x2=20)

Define Distributed Deadlock detection algorithms. Write explain path pushing algorithm for distributed dead lock*' Detection.

(b) (c)

Explain Multiwayjoins and semijoins with example.

Write short notes on

:

(D

Distributed query processing

(i1)

Lazy Replication Techniques.

ECS076/KIH-26391

24625

UPTU B.Tech Distributed Database ECS 076 Sem 7_2011-12.pdf ...

4. Attempt any two parts of the following : (10x2=20I*. (a) Explain Issues ofRecovery in distributed database. Explain. types of failure in distributed system.

604KB Sizes 7 Downloads 314 Views

Recommend Documents

UPTU B.Tech Distributed Systems ECS-701 Sem 7_2011-12.pdf ...
Whoops! There was a problem loading more pages. Retrying... Whoops! There was a problem previewing this document. Retrying... Download. Connect more ...

UPTU B.Tech Database Management System-ECS-402 Sem 4_2009 ...
UPTU B.Tech Database Management System-ECS-402 Sem 4_2009-10.pdf. UPTU B.Tech Database Management System-ECS-402 Sem 4_2009-10.pdf. Open.

UPTU B.Tech Operating System ECS-501 Sem 5_2014-15.pdf ...
UPTU B.Tech Operating System ECS-501 Sem 5_2014-15.pdf. UPTU B.Tech Operating System ECS-501 Sem 5_2014-15.pdf. Open. Extract. Open with. Sign In.

UPTU B.Tech Operatin System ECS- 501 Sem 5_2011-12.pdf ...
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. UPTU B.Tech ...

UPTU B.Tech ECS-602 Software Engineering Sem 6_2010-11.pdf ...
UPTU B.Tech ECS-602 Software Engineering Sem 6_2010-11.pdf. UPTU B.Tech ECS-602 Software Engineering Sem 6_2010-11.pdf. Open. Extract. Open with.

UPTU B.Tech Pattern Recognition ECS-074 Sem 7_2013-14.pdf ...
UPTU B.Tech Pattern Recognition ECS-074 Sem 7_2013-14.pdf. UPTU B.Tech Pattern Recognition ECS-074 Sem 7_2013-14.pdf. Open. Extract. Open with.

UPTU B.Tech IT Infrastructure and Its Managenent -ECS-304 Sem ...
UPTU B.Tech IT Infrastructure and Its Managenent -ECS-304 Sem 3_2010-11.pdf. UPTU B.Tech IT Infrastructure and Its Managenent -ECS-304 Sem ...

UPTU B.Tech Parallel Algorithms ECS 073 Sem 7_2011-12.pdf ...
UPTU B.Tech Parallel Algorithms ECS 073 Sem 7_2011-12.pdf. UPTU B.Tech Parallel Algorithms ECS 073 Sem 7_2011-12.pdf. Open. Extract. Open with.

UPTU B.Tech Pattern Recognition ECS 074 Sem 7_2011-12.pdf ...
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. UPTU B.Tech ...

UPTU B.Tech Computer Graphics ECS-504 Sem 5_2013-14.pdf ...
terms Pixel, Aspect Ratio, Resolution. O) Develop and write mid point circle algorithm. Apply it to. predict the pixels in any octant for the circle whose centre.

UPTU B.Tech Computational Complexity ECS 072 Sem 7_2011-12 ...
UPTU B.Tech Computational Complexity ECS 072 Sem 7_2011-12.pdf. UPTU B.Tech Computational Complexity ECS 072 Sem 7_2011-12.pdf. Open. Extract.

UPTU B.Tech Data Compression ECS 077 Sem 7_2011-12.pdf ...
UPTU B.Tech Data Compression ECS 077 Sem 7_2011-12.pdf. UPTU B.Tech Data Compression ECS 077 Sem 7_2011-12.pdf. Open. Extract. Open with.

UPTU B.Tech Pattern Recognition ECS-074 Sem 7_2015-16.pdf ...
There was a problem loading more pages. Retrying... Whoops! There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. UPTU B.Tech Pattern Recognition ECS-074 Sem 7_20

UPTU B.Tech Operating System ECS-501 Sem 5_2014-15.pdf ...
(e) Enumerate the 'advantages of the layered. approach to system design? Also, Explain. virtual machine architecture in detail. (0 What are Sernaphores?

UPTU B.Tech Computer Graphics ECS-504 Sem 5_2014-15.pdf ...
ll0s041 3 16675. Page 3 of 3. UPTU B.Tech Computer Graphics ECS-504 Sem 5_2014-15.pdf. UPTU B.Tech Computer Graphics ECS-504 Sem 5_2014-15.pdf.

UPTU B.Tech Object Oriented Systems- ECS-305 Sem 3_2010-11 ...
Page 3 of 4. UPTU B.Tech Object Oriented Systems- ECS-305 Sem 3_2010-11.pdf. UPTU B.Tech Object Oriented Systems- ECS-305 Sem 3_2010-11.pdf. Open.

UPTU B.Tech Operating System ECS-501 Sem 5_2013-14.pdf ...
UPTU B.Tech Operating System ECS-501 Sem 5_2013-14.pdf. UPTU B.Tech Operating System ECS-501 Sem 5_2013-14.pdf. Open. Extract. Open with. Sign In.

UPTU B.Tech Compiler Design - ECS 603 Sem 6_2013-14.pdf ...
UPTU B.Tech Compiler Design - ECS 603 Sem 6_2013-14.pdf. UPTU B.Tech Compiler Design - ECS 603 Sem 6_2013-14.pdf. Open. Extract. Open with. Sign In.

UPTU B.Tech Operating System ECS-501 Sem 5_2013-14.pdf ...
OPERATINGSYSTEM. Time : 3 Hours ... favour of the oldest process. Draw the Gantt ... Displaying UPTU B.Tech Operating System ECS-501 Sem 5_2013-14.pdf.

UPTU B.Tech Data Mining & Data Warehousing ECS 075 Sem ...
UPTU B.Tech Data Mining & Data Warehousing ECS 075 Sem 7_2011-12.pdf. UPTU B.Tech Data Mining & Data Warehousing ECS 075 Sem 7_2011-12.pdf.

UPTU B.Tech TCS-402 Database Management System Sem 4_2010 ...
UPTU B.Tech TCS-402 Database Management System Sem 4_2010-11.pdf. UPTU B.Tech TCS-402 Database Management System Sem 4_2010-11.pdf. Open.

UPTU B.Tech Digital Logic Design-ECS-301 Sem 3_ 2009-10.pdf ...
UPTU B.Tech Digital Logic Design-ECS-301 Sem 3_ 2009-10.pdf. UPTU B.Tech Digital Logic Design-ECS-301 Sem 3_ 2009-10.pdf. Open. Extract. Open with.