One way to avoid deadlock is to schedule threads carefully. Assume the following characteristics of threads T1, T2, T3 and T4: • T1 (at some point) acquires and releases locks L1, L2 and L5 • T2 (at some point) acquires and releases locks L2, L3 and L4 • T3 (at some point) acquires and releases locks L1, L2 and L4 • T4 (at some point) acquires and releases locks L3, L4 and L5 For which schedules below is deadlock possible? (a) T4, T2, T3, and T1 run concurrently. (b) T1 and T2 run concurrently to completion, then T3 runs to completion, then T4 runs. (c) T1 and T3 run concurrently to completion, then T2 and T4 run concurrently to completion. (d) T2 and T4 run concurrently to completion, then T1 runs to completion. (e) T1 and T4 run concurrently to completion, T1 finishes first after which T4 continuous to run to completion with T2.

One way to avoid deadlock is to schedule threads carefully. Assume the following characteristics of threads T1, T2, T3 and T4: • T1 (at some point) acquires and releases locks L1, L2 and L5 • T2 (at some point) acquires and releases locks L2, L3 and L4 • T3 (at some point) acquires and releases locks L1, L2 and L4 • T4 (at some point) acquires and releases locks L3, L4 and L5 For which schedules below is deadlock possible? (a) T4, T2, T3, and T1 run concurrently. (b) T1 and T2 run concurrently to completion, then T3 runs to completion, then T4 runs. (c) T1 and T3 run concurrently to completion, then T2 and T4 run concurrently to completion. (d) T2 and T4 run concurrently to completion, then T1 runs to completion. (e) T1 and T4 run concurrently to completion, T1 finishes first after which T4 continuous to run to completion with T2.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What was the name of Ada Lovelace's father?
8. Prepare SQL statement to find more than ONE (1) students supervised by an advisor. Display advisor name and number of advisee. Label the columns as AdvisorName, and NumberofSupervision respectively. SQL statements:
last 3 subparts
not what was asked
Only one correct answer, Which one?
please send correct answer Q3
What is the precise meaning of the phrase "select numbers randomly" as used by an individual?
Which are the types of Triggers?
What are the Automated SQL injection attacks using sql map
SQL
Enumerate 5 Best Practices in Writing SQL statements
Why can the virtualizing appliances that are i/o(input output) heavy possibly be detrimental to performance?