Compare and contrast the approaches to deadlock management in database systems.

What will be an ideal response?


Deadlock free => claim all resources at once.
Deadlock prevention => order resources.
Deadlock detection => generate WFGs. Break cycle(s) by rolling back one or more transactions and restarting them.

Computer Science & Information Technology

You might also like to view...

What is the value stored in num after the following statement executes?

``` num = atoi("1000"); ``` a. 1000 b. 999 c. "1000" d. "1 thousand" e. None of these

Computer Science & Information Technology

Select the correct rules for encapsulation. If any rules need to be imposed in a particular order, then say so, mentioning which rules.

a. Make all class member variables public members of the class. b. Place the interface in the header file. What is the interface? c. Place the implementation in a separate code file (with file extension required by your compiler: .cpp, .cxx, etc), called the implementation file. What is the implementation? d. Having private members visible in the interface violates the philosophy of separating the interface from the implementation. Separate interface and implementation requires removal of all the private members from the class definition. You must put these in another part of the class definition in the implementation.

Computer Science & Information Technology

Heap sort is an __________ sorting algorithm.

a) O(1) b) O(n) c) O(n log n) d) O() e) none of the above

Computer Science & Information Technology

Although you can create calculated fields in a query, most prefer to add them the table instead.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology