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

adminhan

&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"><o:p></o:p></span></p>
A:<p class="MsoNormal" style="TEXT-INDENT: 21pt"><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"><o:p></o:p></span></p><p class="MsoNormal" style="TEXT-INDENT: 21pt"><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>
B:&nbsp;&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>
C:<p class="MsoNormal" style="TEXT-INDENT: 21pt"><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"><o:p></o:p></span></p><p class="MsoNormal" style="TEXT-INDENT: 21pt"><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>
D:&nbsp;&nbsp;&nbsp;&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>

&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;</span></span></p>
A:<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-spacerun: yes">&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="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;</span><span style="mso-spacerun: yes">&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"><span style="mso-spacerun: yes">&nbsp;</span></span></span>
D:高级程序

&nbsp; <p class="MsoPlainText"><span lang="EN-US" style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">&nbsp;</span><span style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">三层客户机<span lang="EN-US">/</span>服务器结构的模型是<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoPlainText"><span lang="EN-US" style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'"><span style="mso-spacerun: yes">&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></p>
A:&nbsp;<span style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">客户机&mdash;应用服务器&mdash;数据库服务器<span lang="EN-US"><o:p></o:p></span></span> <p class="MsoPlainText"><span lang="EN-US" style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'"><span style="mso-spacerun: yes">&nbsp;</span><span style="mso-spacerun: yes">&nbsp; </span></span></p>
B:&nbsp;<span style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">客户机&mdash;数据服务器&mdash;应用服务器<span lang="EN-US"><o:p></o:p></span></span> <p class="MsoPlainText"><span lang="EN-US" style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'"><span style="mso-spacerun: yes">&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></p>
C:. <span style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">数据客户机&mdash;应用客户机&mdash;服务器<span lang="EN-US"><o:p></o:p></span></span> <p class="MsoPlainText"><span lang="EN-US" style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'"><span style="mso-spacerun: yes">&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></p>
D:<span style="mso-spacerun: yes">&nbsp;</span> <span style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">应用客户机&mdash;数据客户机&mdash;服务器<span lang="EN-US"><o:p></o:p></span></span>

&nbsp; <p class="MsoNormal"><span style="FONT-FAMILY: 宋体">在<span lang="EN-US">SQL</span>中，与&ldquo;<span lang="EN-US">NOT</span>　<span lang="EN-US">IN</span>&rdquo;等价的操作符是<span lang="EN-US"><o:p></o:p></span></span></p>
A:<p class="MsoNormal" style="MARGIN-LEFT: 10.5pt; TEXT-INDENT: 5.25pt; mso-char-indent-count: .5; mso-para-margin-left: 1.0gd"><span style="FONT-FAMILY: 宋体"><span lang="EN-US">&lt;&gt;ALL<span style="mso-tab-count: 5">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></span></p>
B:<span lang="EN-US">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;&gt;SOME<o:p></o:p></span>
C:<p class="MsoNormal" style="MARGIN-LEFT: 10.5pt; TEXT-INDENT: 5.25pt; mso-char-indent-count: .5; mso-para-margin-left: 1.0gd"><span style="FONT-FAMILY: 宋体"><span lang="EN-US">=SOME<span style="mso-tab-count: 6">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></p>
D:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span lang="EN-US">=ALL<o:p></o:p></span>

&nbsp; <p class="MsoNormal"><span style="FONT-FAMILY: 宋体">下面说法正确的是<span lang="EN-US"><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="mso-spacerun: yes">&nbsp;</span></span></span></p>
A:&nbsp;当客户从一个网页转到另一个网页时，保存在<span lang="EN-US">Session</span>中的信息回丢失<span lang="EN-US"><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>
B:<span style="mso-spacerun: yes">&nbsp;&nbsp;</span><span lang="EN-US">Session</span>对象的有效期默认为<span lang="EN-US">40</span>分钟<span lang="EN-US"><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="mso-spacerun: yes">&nbsp;</span></span>
C:&nbsp;<span style="mso-spacerun: yes">&nbsp;</span><span lang="EN-US">session</span>对象的有效期不能更改<span lang="EN-US"><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="mso-spacerun: yes">&nbsp; </span></span>
D:<span style="mso-spacerun: yes">&nbsp;</span><span lang="EN-US">Session</span>对象到期前可以用<span lang="EN-US">Abandon</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;&nbsp; </span></span></p>
A:<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">INTEGER&nbsp;<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;</span></span></span>
B:<span lang="EN-US">INT<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;&nbsp; </span></span></p>
C:<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">NUMERIC<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
D:<span lang="EN-US">SMALLINT<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 style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></p>
A:<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">行<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&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="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></p>
C:&nbsp;&nbsp;<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">列<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></span>
D:&nbsp;<span style="mso-spacerun: yes">&nbsp;</span>字段

&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"><o:p></o:p></span></p><p class="MsoNormal"><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;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></p>
A:<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">DBMS</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;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;</span></span>
B:<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">DBMS</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 class="MsoNormal"><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;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></p>
C:<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">DBMS<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;</span></span>
D:<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">DBMS<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;&nbsp;</span></span></p>
A:<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">createdatabase<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></span>
B:&nbsp;<span lang="EN-US">createtable<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;&nbsp;</span></span></p>
C:&nbsp;<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">insert<span style="mso-spacerun: yes">&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
D:<span lang="EN-US">backuplog<o:p></o:p></span>

&nbsp; <p class="MsoNormal"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">下面的说法不确切的是<span lang="EN-US" style="mso-bidi-font-weight: bold"> <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;&nbsp;</span></span></p>
A:&nbsp;<span style="mso-bidi-font-weight: bold"> </span><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold">索引用来加速数据的访问速度和保证表的实体完整性的数据库对象。<span lang="EN-US"><o:p></o:p></span></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;&nbsp; </span></span></p>
B:&nbsp;<span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold">索引有聚集和非聚集索引两种。<span lang="EN-US"><o:p></o:p></span></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;&nbsp; </span></span></p>
C:&nbsp;<span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold">聚集索引使表的物理顺序与索引顺序一致，一个表只能有一个聚集索引。<span lang="EN-US"><o:p></o:p></span></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;&nbsp; </span></span></p>
D:&nbsp;<span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold">非聚集索引与表的物理顺序无关，一个表应该建立多个非聚集索引。</span>

<p class="MsoNormal"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-bidi-font-weight: bold">常用的备份存储介质包括硬盘。<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 lang="EN-US">&ldquo;</span>关系<span lang="EN-US">&rdquo;</span>这个术语来自于数学中的集合概念。<span lang="EN-US"><o:p></o:p></span></span></p>
A:错误
B:正确

<p class="MsoNormal"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">实现数据备份的关键技术是数据转储和建立日志文件。</span><span lang="EN-US" style="mso-bidi-font-size: 10.5pt"><o:p></o:p></span></p>
A:错误
B:正确

<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>
A:错误
B:正确

<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>
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 2005</span><span style="mso-bidi-font-weight: bold">的新特性使索引性能增强，可以在计算列行创建索引。<span lang="EN-US"><o:p></o:p></span></span></span></p>
A:错误
B:正确