Answer the following questions.
Question 1) Describe the role played by distributed query processor.
Question 2) What is search space and search strategy?
Question 3) Describe what is phantom.
Question 4) Distinguish between MTBF & MTTR.
Question 5) Describe how inplace update and out of place updating takes place.
Question 6) What is basic purpose of conservative time stamp ordering.
Question 7) Describe with diagram the working of distributed execution monitor.
Question 8) What are the problems which arises during query processing?
Question 9) What are categories of information need to be maintained in case of a fragmentation.
Question 10) Describe MDBMS architecture with GCS and without GCS.
Question 11) Explain the steps involved in generation of CA.
Question 12) Write 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) Write (x)
x = x – 100 x = x – 10 Read (y)
Write (y) y = y – 50 y = y –100
Write (x) z = z – 10 Write (y)
Read (z) Write (x) Read (z)
z = z – x Write (y) z = x – y
Write (z) Write (z) Write (z)