Question: 3 . ( 6 points ) Consider the following extendable hashing index. 2 0 * 4 * 8 * 1 2 * 3 1 *

3.(6 points) Consider the following extendable hashing index.
2
0*4*8*12*
3
1* g*17*
3
3
000
001
010
011
100
101
110
2
111
3*
7*
11*15*
3
6*
14
2*10"26"
513
a)(3 points) Show the index that would result from inserting a data entry with key 16.
b)(3 points) Given the result of (a), show the index that would result from inserting a data entry with key 20.
4.(6 points) Consider the following schedules.
S: W3(A);R1(B);W1(B); R1(B);W3(C);W2(B);W2(D);R2(C);W2(C);R3(A);R3(C);R3(A);C1;C3;C2
Draw the precedence graph for the schedule. Is the schedule conflict-serializable? Is the schedule recoverable?
5.(6 points) Consider the following schedule.
S: W1(B);R2(A);W3(A);W1(C);R3(B);W1(A);R3(B);R1(A);W1(A);R1(A);C1;C2;C3
Assume that Strict 2PL is applied to the schedules. Draw both timetables (including shared and exclusive locks and unlock actions) and wait-for-graph. Does the schedule have a deadlock?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!