?? multiple-choice quiz 7----9.mht
字號:
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination:w=
idow-orphan'><a
name=3D6860277></a><span lang=3DEN-US style=3D'font-size:12.0pt;font-family=
:SimSun;
mso-bidi-font-family:SimSun;display:none;mso-hide:all;mso-font-kerning:0pt'=
><o:p> </o:p></span></p>
<table class=3DMsoNormalTable border=3D0 cellpadding=3D0 style=3D'mso-cells=
pacing:1.5pt'>
<tr style=3D'mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
<td width=3D25 style=3D'width:18.75pt;padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p> </o:p></span></p>
</td>
<td style=3D'padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-f=
amily:
SimSun;color:black;mso-font-kerning:0pt'><INPUT TYPE=3D"radio" NAME=3D"68=
60277" VALUE=3D"6860287"></span><span
lang=3DEN-US style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(a) The
transaction can acquire locks, and can release its locks as long as the
number of released locks is greater than the number of acquired locks.</s=
pan><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-f=
amily:
SimSun;color:black;mso-font-kerning:0pt'><br>
<INPUT TYPE=3D"radio" NAME=3D"6860277" VALUE=3D"6860278"></span><span lang=
=3DEN-US
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(b) The
transaction can acquire locks, but cannot release its locks.</span><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-f=
amily:
SimSun;color:black;mso-font-kerning:0pt'><br>
<INPUT TYPE=3D"radio" NAME=3D"6860277" VALUE=3D"6860285"></span><span lang=
=3DEN-US
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(c) The
transaction can acquire locks, and can release its locks.</span><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-f=
amily:
SimSun;color:black;mso-font-kerning:0pt'><br>
<INPUT TYPE=3D"radio" CHECKED NAME=3D"6860277" VALUE=3D"6860272"></span><sp=
an
lang=3DEN-US style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(d) The
transaction cannot acquire locks, but can release its locks.</span><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-f=
amily:
SimSun;color:black;mso-font-kerning:0pt'> <o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination:w=
idow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-fam=
ily:
SimSun;display:none;mso-hide:all;mso-font-kerning:0pt'><o:p> </o:p></s=
pan></p>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center;mso-pagina=
tion:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-fam=
ily:
SimSun;mso-font-kerning:0pt'>
<hr size=3D2 width=3D"100%" align=3Dcenter>
</span></div>
<table class=3DMsoNormalTable border=3D0 cellpadding=3D0 style=3D'mso-cells=
pacing:1.5pt'>
<tr style=3D'mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
<td width=3D10 style=3D'width:7.2pt;padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p> </o:p></span></p>
</td>
<td width=3D12 nowrap valign=3Dtop style=3D'width:9.0pt;padding:.75pt .75=
pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dright style=3D'text-align:right;mso-paginati=
on:widow-orphan'><span
lang=3DEN-US style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>4.</span><s=
pan
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p></o:p></span></p>
</td>
<td width=3D10 style=3D'width:7.2pt;padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p> </o:p></span></p>
</td>
<td style=3D'padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>The strict
two-phase locking protocol is _____ to implement.</span><span lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-family:SimSun;
color:black;mso-font-kerning:0pt'><o:p></o:p></span></p>
</td>
<td width=3D10 style=3D'width:7.2pt;padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p> </o:p></span></p>
</td>
</tr>
</table>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination:w=
idow-orphan'><a
name=3D6860282></a><span lang=3DEN-US style=3D'font-size:12.0pt;font-family=
:SimSun;
mso-bidi-font-family:SimSun;display:none;mso-hide:all;mso-font-kerning:0pt'=
><o:p> </o:p></span></p>
<table class=3DMsoNormalTable border=3D0 cellpadding=3D0 style=3D'mso-cells=
pacing:1.5pt'>
<tr style=3D'mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
<td width=3D25 style=3D'width:18.75pt;padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p> </o:p></span></p>
</td>
<td style=3D'padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-f=
amily:
SimSun;color:black;mso-font-kerning:0pt'><INPUT TYPE=3D"radio" NAME=3D"68=
60282" VALUE=3D"6860283"></span><span
lang=3DEN-US style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(a) more
difficult than most two-phase locking protocols</span><span lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-family:SimSun;
color:black;mso-font-kerning:0pt'><br>
<INPUT TYPE=3D"radio" NAME=3D"6860282" VALUE=3D"6860281"></span><span lang=
=3DEN-US
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(b) easier =
than
most two-phase locking protocols</span><span lang=3DEN-US style=3D'font-s=
ize:
9.0pt;font-family:Verdana;mso-bidi-font-family:SimSun;color:black;mso-fon=
t-kerning:
0pt'><br>
<INPUT TYPE=3D"radio" CHECKED NAME=3D"6860282" VALUE=3D"6860284"></span><sp=
an
lang=3DEN-US style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(c) the eas=
iest
two-phase locking protocol</span><span lang=3DEN-US style=3D'font-size:9.=
0pt;
font-family:Verdana;mso-bidi-font-family:SimSun;color:black;mso-font-kern=
ing:
0pt'><br>
<INPUT TYPE=3D"radio" NAME=3D"6860282" VALUE=3D"6860280"></span><span lang=
=3DEN-US
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(d) the most
difficult two-phase locking protocol</span><span lang=3DEN-US style=3D'fo=
nt-size:
9.0pt;font-family:Verdana;mso-bidi-font-family:SimSun;color:black;mso-fon=
t-kerning:
0pt'> <o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination:w=
idow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-fam=
ily:
SimSun;display:none;mso-hide:all;mso-font-kerning:0pt'><o:p> </o:p></s=
pan></p>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center;mso-pagina=
tion:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-fam=
ily:
SimSun;mso-font-kerning:0pt'>
<hr size=3D2 width=3D"100%" align=3Dcenter>
</span></div>
<table class=3DMsoNormalTable border=3D0 cellpadding=3D0 style=3D'mso-cells=
pacing:1.5pt'>
<tr style=3D'mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
<td width=3D10 style=3D'width:7.2pt;padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p> </o:p></span></p>
</td>
<td width=3D12 nowrap valign=3Dtop style=3D'width:9.0pt;padding:.75pt .75=
pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dright style=3D'text-align:right;mso-paginati=
on:widow-orphan'><span
lang=3DEN-US style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>5.</span><s=
pan
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p></o:p></span></p>
</td>
<td width=3D10 style=3D'width:7.2pt;padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p> </o:p></span></p>
</td>
<td style=3D'padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>A <span
class=3DSpellE>livelock</span> occurs when</span><span lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-family:SimSun;
color:black;mso-font-kerning:0pt'><o:p></o:p></span></p>
</td>
<td width=3D10 style=3D'width:7.2pt;padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p> </o:p></span></p>
</td>
</tr>
</table>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination:w=
idow-orphan'><a
name=3D6860287></a><span lang=3DEN-US style=3D'font-size:12.0pt;font-family=
:SimSun;
mso-bidi-font-family:SimSun;display:none;mso-hide:all;mso-font-kerning:0pt'=
><o:p> </o:p></span></p>
<table class=3DMsoNormalTable border=3D0 cellpadding=3D0 style=3D'mso-cells=
pacing:1.5pt'>
<tr style=3D'mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes'>
<td width=3D25 style=3D'width:18.75pt;padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:12.0pt;font-family:SimSun;mso-bidi-font-f=
amily:
SimSun;mso-font-kerning:0pt'><o:p> </o:p></span></p>
</td>
<td style=3D'padding:.75pt .75pt .75pt .75pt'>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination=
:widow-orphan'><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-f=
amily:
SimSun;color:black;mso-font-kerning:0pt'><INPUT TYPE=3D"radio" NAME=3D"68=
60287" VALUE=3D"6860292"></span><span
lang=3DEN-US style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(a) an abor=
ted
transaction holding a lock is restarted</span><span lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-family:SimSun;
color:black;mso-font-kerning:0pt'><br>
<INPUT TYPE=3D"radio" NAME=3D"6860287" VALUE=3D"6860295"></span><span lang=
=3DEN-US
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(b) 2 or mo=
re
transactions wait indefinitely because each holds the data items of anoth=
er</span><span
lang=3DEN-US style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-f=
amily:
SimSun;color:black;mso-font-kerning:0pt'><br>
<INPUT TYPE=3D"radio" NAME=3D"6860287" VALUE=3D"6860290"></span><span lang=
=3DEN-US
style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-family:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(c) a
transaction holding a lock is aborted</span><span lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-family:SimSun;
color:black;mso-font-kerning:0pt'><br>
<INPUT TYPE=3D"radio" CHECKED NAME=3D"6860287" VALUE=3D"6860293"></span><sp=
an
lang=3DEN-US style=3D'font-size:9.0pt;mso-bidi-font-size:12.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'>(d) a
transaction is aborted and restarted repeatedly</span><span lang=3DEN-US
style=3D'font-size:9.0pt;font-family:Verdana;mso-bidi-font-family:SimSun;
color:black;mso-font-kerning:0pt'> <o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=3DMsoNormal align=3Dleft style=3D'text-align:left;mso-pagination:w=
idow-orphan'><span
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -