25-08-2017, 09:32 PM
Assignments Question
Assignments.docx (Size: 14.66 KB / Downloads: 45)
Two marks Questions
1. What is deadlock?
2. List the steps in query processing.
3. Draw state diagram of a transaction.
4. Define transaction.
5. How deadlock is detected and recovered.
6. What is serializability?
7. What is equivalence expression?
8. What is schedule? List its 2 types.
Four Marks Question
1. Define Locking. Explain time stamp based locking protocol.
2. Describe ACID properties of transaction.
3. What is cascade less schedule? Explain with example.
4. What is meant by schedule? Explain with example concurrent schedule.
5. Explain what is meant by equivalence of expression?
6. Explain two methods of deadlock prevention.
7. Explain share and exclusive type of lock.
8. Describe various stages of query processing with suitable diagram.
9. Explain the concept of serializability related to transaction processing.
Eight Marks Question
1. What do you mean by lock based protocol? Explain 2 phase locking protocol with example.
2. Explain the term serializability with example.
3. Explain time-stamp based protocol.
a. Time-stamp ordering
b. Validation-based protocol.