📄 multiple-choice quiz 4----6.mht
字号:
></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;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt'>
<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'>2.</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 vertical =
view
allows users access to</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'><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=3D6859820></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;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt'>
<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=
59820" VALUE=3D"6859816"></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) only
specific rows of the defining tables</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'><br>
<INPUT TYPE=3D"radio" NAME=3D"6859820" VALUE=3D"6859822"></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) only the
user tables</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"6859820" VALUE=3D"6859829"></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) only the
system tables</span><span lang=3DEN-US style=3D'font-size:9.0pt;font-fami=
ly:Verdana;
mso-bidi-font-family:SimSun;color:black;mso-font-kerning:0pt'><br>
<INPUT TYPE=3D"radio" CHECKED NAME=3D"6859820" VALUE=3D"6859819"></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) only
specific columns of the defining tables</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
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;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt'>
<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'>3.</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'>Which of the
following is true about views being up to date?</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=3D6859825></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;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt'>
<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" CHECKED NA=
ME=3D"6859825" VALUE=3D"6859826"></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) Views a=
re
always up to date.</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"6859825" VALUE=3D"6859825"></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) Views a=
re
never up to date; there is always a lag time.</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"6859825" VALUE=3D"6859827"></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) Views c=
an
be automatically made up to date periodically by the system.</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"6859825" VALUE=3D"6859828"></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) Views a=
re
up to date only after the synchronization operation by the user.</span><s=
pan
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;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt'>
<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'>Consider two
tables, <span class=3DGramE>Employee(</span><span class=3DSpellE>EmpNo</s=
pan>,
Name, <span class=3DSpellE>DeptNo</span>) and Department(<span class=3DSp=
ellE>DeptNo</span>,
Name, Manager) with primary keys being <span class=3DSpellE>EmpNo</span> =
and <span
class=3DSpellE>DeptNo</span> respectively. The <span class=3DSpellE>DeptN=
o</span>
attribute of the Employee table has a NOT NULL constraint and is a foreign
key that references the <span class=3DSpellE>DeptNo</span> attribute of t=
he
Department table. The Manager attribute of the Department table has a NOT
NULL constraint and is a foreign key that references the <span class=3DSp=
ellE>EmpNo</span>
attribute of the Employee table. When the tables are empty, the only way =
to
insert rows into the two tables is</span><span lang=3DEN-US style=3D'font=
-size:
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -