20春学期《数据库技术及应用Ⅱ》在线平时作业3

adminhan

&nbsp; <p class="MsoNormal"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">在登录日志文件时，应该<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoNormal"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></p>
A:&nbsp;<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">将更新数据库与登录日志文件两个操作同时完成<span lang="EN-US"><o:p></o:p></span></span> <p class="MsoNormal"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp; </span></span></p>
B:<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">将更新数据库与登录日志文件两个操作按随机的先后顺序完成<span lang="EN-US"><o:p></o:p></span></span> <p class="MsoNormal"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></p>
C:&nbsp;<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">先写数据库的更新，后登录日志文件<span lang="EN-US"><o:p></o:p></span></span> <p class="MsoNormal"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></p>
D:<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">先登录日志文件，后写数据库的更新<span lang="EN-US"><o:p></o:p></span></span>

&nbsp; <p class="MsoNormal" style="tab-stops: 252.0pt 261.0pt 279.0pt"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">不允许任何其它事务对这个锁定目标再加上任何类型锁的是<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoNormal" style="tab-stops: 210.0pt 261.0pt 279.0pt"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></p>
A:&nbsp;<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">共享锁<span lang="EN-US"><span style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span>
B:排它锁<span lang="EN-US"><o:p></o:p></span> <p class="MsoNormal" style="tab-stops: 210.0pt 261.0pt 279.0pt"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></p>
C:&nbsp;<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">死锁<span lang="EN-US"><span style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
D:&nbsp;活锁

&nbsp; <p class="MsoNormal"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Calibri">把</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-size: 10.5pt">ER</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Calibri">图转换成关系模型的过程，属于数据库设计中的</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-size: 10.5pt"><o:p></o:p></span></p>
A:<p class="MsoNormal" style="TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp; </span></span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Calibri">概念设计</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span></span></p>
B:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Calibri">逻辑设计</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-size: 10.5pt"><o:p></o:p></span> <p class="MsoNormal" style="TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;</span></span></p>
C:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Calibri">需求分析</span><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span></span>
D:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-ascii-font-family: Calibri">物理设计</span>

&nbsp; <p class="MsoNormal"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">在标准<span lang="EN-US">SQL</span>中，建立数据库表结构的命令是<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoNormal"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span></span></p>
A:<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">CREATE SCHEMA</span>命令<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span>
B:<span lang="EN-US">CREATE TABLE</span>命令<span lang="EN-US"><o:p></o:p></span> <p class="MsoNormal"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span></span></p>
C:&nbsp;<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">CREATE VIEW</span>命令<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
D:&nbsp;<span lang="EN-US">CREATE INDEX</span>命令

&nbsp; <p class="MsoNormal" style="tab-stops: 198.0pt"><span lang="EN-US" style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">&nbsp;</span><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">恢复机制的关键问题是建立冗余数据，最常用的技术是<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoNormal" style="tab-stops: 198.0pt"><span lang="EN-US" style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></p>
A:&nbsp;<span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">数据镜像<span lang="EN-US"><span style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span>
B:&nbsp;数据转储<span lang="EN-US"><o:p></o:p></span> <p class="MsoNormal" style="tab-stops: 198.0pt"><span lang="EN-US" style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </span></span></p>
C:&nbsp;<span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">登录日志文件<span lang="EN-US"><span style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span>
D:&nbsp;B＋<span lang="EN-US">C<o:p></o:p></span>

&nbsp; <p class="MsoNormal" style="tab-stops: 252.0pt 261.0pt 279.0pt"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">当应用系统通过<span lang="EN-US">ODBC</span>执行<span lang="EN-US">SQL</span>语句时，<span lang="EN-US">ODBC</span>提供了两种不同的执行方法<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoNormal" style="tab-stops: 210.0pt 261.0pt 279.0pt"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></p>
A:&nbsp;<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">直接执行和间接执行<span lang="EN-US"><span style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span>
B:&nbsp;直接执行和无准备地执行<span lang="EN-US"><o:p></o:p></span> <p class="MsoNormal" style="tab-stops: 210.0pt 261.0pt 279.0pt"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp; </span></span></p>
C:<span style="mso-spacerun: yes">&nbsp;</span> <span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">直接执行和有准备地执行<span lang="EN-US"><span style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
D:&nbsp;间接执行和有准备地执<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">行<span lang="EN-US"><o:p></o:p></span></span>

&nbsp; <p class="MsoNormal" style="MARGIN-LEFT: 15.75pt; TEXT-INDENT: -15.75pt; tab-stops: 212.65pt; mso-char-indent-count: -1.5"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">SQL</span>语言的<span lang="EN-US">GRANT</span>命令可以授予用户的权限，但其中没有<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoNormal" style="MARGIN-LEFT: 15.75pt; TEXT-INDENT: -15.75pt; tab-stops: 212.65pt; mso-char-indent-count: -1.5"><span lang="EN-US" style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></p>
A:&nbsp;<span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">SELECT<span style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
B:&nbsp;<span lang="EN-US">DELETE<o:p></o:p></span> <p class="MsoNormal" style="MARGIN-LEFT: 15.75pt; TEXT-INDENT: -15.75pt; tab-stops: 212.65pt; mso-char-indent-count: -1.5"><span lang="EN-US" style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></p>
C:<span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">UODATA<span style="mso-tab-count: 1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
D:<span lang="EN-US">CREATE TABLE<o:p></o:p></span>

&nbsp; <p class="MsoNormal"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">当数据的全局逻辑结构改变时，数据的局部逻辑结构可以不变，从而应用程序也不<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoNormal"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp; </span></span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">用改变这就是数据与程序的<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoNormal"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span></span></p>
A:&nbsp; <span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">物理独立性<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span>
B:逻辑独立性<span lang="EN-US"><o:p></o:p></span> <p class="MsoNormal"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span></span></p>
C:&nbsp;<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">一致性<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
D:&nbsp;完整性<span lang="EN-US"><o:p></o:p></span>

&nbsp; <p class="MsoNormal"><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">如果两个实体之间的联系是</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt">1</span><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">：</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt">M</span><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">，则实现</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt">l</span><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">：</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt">M</span><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">联系的方法是</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt"><o:p></o:p></span></p>
A:<p class="MsoNormal" style="TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;</span></span><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">将两个实体转换成一个关系</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt"><o:p></o:p></span></p><p class="MsoNormal" style="TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;</span></span></p>
B:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">将两个实体转换的关系中，分别加入另一个关系的主码。</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt"><o:p></o:p></span>
C:<p class="MsoNormal" style="TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp; </span></span><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">将</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt">&ldquo;1&rdquo;</span><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">端实体转换的关系的主码，放入</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt">&ldquo;M&rdquo;</span><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">端实体转换的关系中</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt"><o:p></o:p></span></p><p class="MsoNormal" style="TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;</span></span></p>
D:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">将</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt">&ldquo;M&rdquo;</span><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">端实体转换的关系的主码，放入</span><span lang="EN-US" style="FONT-FAMILY: 'Calibri','sans-serif'; COLOR: black; mso-bidi-font-size: 10.5pt">&ldquo;1&rdquo;</span><span style="FONT-FAMILY: 宋体; COLOR: black; mso-ascii-font-family: Calibri; mso-bidi-font-size: 10.5pt">端实体转换的关系中</span>

&nbsp; <p class="MsoNormal"><span lang="EN-US" style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">&nbsp;</span><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">下列没有保存在事务日志中的是<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoNormal"><span lang="EN-US" style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></p>
A:&nbsp; <span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">所有读取数据库的操作<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
B:&nbsp; 数据更新前的值<span lang="EN-US"><o:p></o:p></span> <p class="MsoNormal"><span lang="EN-US" style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </span></span></p>
C:&nbsp;<span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">数据更新后的值<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
D:&nbsp;事务开始与终止的信息

&nbsp; <p class="MsoNormal"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US" style="mso-bidi-font-weight: bold">Web</span><span style="mso-bidi-font-weight: bold">数据库的结构第二层是实现业务逻辑的<span lang="EN-US">Web</span>服务器。<span lang="EN-US"><o:p></o:p></span></span></span></p>
A:错误
B:正确

<p class="MsoNormal"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-bidi-font-weight: bold">在安装<span lang="EN-US">SQL Server</span>后，默认数据库包含两个用户：<span lang="EN-US">dbo</span>和<span lang="EN-US">guest</span>。</span><span lang="EN-US"><o:p></o:p></span></span></p>
A:错误
B:正确

<p class="MsoNormal"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-bidi-font-weight: bold">文件系统的缺点之一表现在改变数据的逻辑结构就必须修改数据库。<span lang="EN-US"><o:p></o:p></span></span></span></p>
A:错误
B:正确

<p class="MsoNormal"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-bidi-font-weight: bold">触发器是一种特殊类型的存储过程。<span lang="EN-US"><o:p></o:p></span></span></span></p>
A:错误
B:正确

<p class="MsoNormal"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">CREATE TABLE</span>语句的<span lang="EN-US">ON DELETE RESTRICT</span>子句实现</span><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">删除限制<span style="COLOR: black">功能。<span lang="EN-US"><o:p></o:p></span></span></span></p>
A:错误
B:正确

<p class="MsoNormal"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US" style="mso-bidi-font-weight: bold">SQL Server</span><span style="mso-bidi-font-weight: bold">的数据库文件组是<span lang="EN-US">SQL</span>另一种形式的容器。<span lang="EN-US"><o:p></o:p></span></span></span></p>
A:错误
B:正确