Answer the following problems.

problem 1) Describe the role played by distributed query processor.

problem 2) What is search space and search strategy?

problem 3) Describe what is phantom.

problem 4) Distinguish between MTBF & MTTR.

problem 5) Describe how inplace update and out of place updating takes place.

problem 6) What is basic purpose of conservative time stamp ordering.

problem 7) Describe with diagram the working of distributed execution monitor.

problem 8) What are the problems which arises during query processing?

problem 9) What are categories of information need to be maintained in case of a fragmentation.

problem 10) Describe MDBMS architecture with GCS and without GCS.

problem 11) describe the steps involved in generation of CA.

problem 12) prepare down at least one serializable and one Non serializable schedule for the following transaction:

T1                                   T2                           T3
Read (y)                    Read (x)                 Read (x)
y = y –10                   Read (y)                x = x – 50
Read (x)                     Read (z)               prepare (x)
x = x – 100                x = x – 10               Read (y)
prepare (y)                    y = y – 50               y = y –100
prepare (x)                    z = z – 10                prepare (y)
Read (z)                     prepare (x)                  Read (z)
z = z – x                     prepare (y)                 z = x – y
prepare (z)                    prepare (z)                 prepare (z)