超前自学网

 找回密码
 立即注册

奥鹏在线作业,2元一门,先做后付,微信424329

查看: 54|回复: 0

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

[复制链接]

3万

主题

3万

帖子

9万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
95816
发表于 2020-8-8 18:59:56 | 显示全部楼层 |阅读模式
微信公众号:超前自学网
点击这里
&nbsp; <p class="MsoNormal"><span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">在第一个事务以共享锁方式读数据<span lang="EN-US">A</span>时,其他事务对数据<span lang="EN-US">A</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 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"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;</span><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;</span><span style="mso-spacerun: yes">&nbsp;&nbsp; </span></span></p>
C:<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;</span><span style="mso-spacerun: yes">&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></span>
D:读写等待

<span lang="EN-US" style="FONT-SIZE: 10.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">DB</span><span style="FONT-SIZE: 10.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-family: 'Times New Roman'; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">是</span>
A:&nbsp; <p class="MsoNormal" style="TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><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 style="mso-spacerun: yes">&nbsp;</span></span></span></p>
B:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 数据库管理系统<span lang="EN-US"><o:p></o:p></span>
C:<p class="MsoNormal" style="TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><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></p>
D:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 数据库系统

&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:&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 style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
B:&nbsp;&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;</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;</span></span></span>
D:&nbsp;面向对象模型

<p class="MsoNormal" style="MARGIN-LEFT: 21pt; TEXT-INDENT: -21pt; mso-char-indent-count: -2.0"><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 lang="EN-US"><o:p></o:p></span></span></p>
A:<p class="MsoNormal" style="TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><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;&nbsp;&nbsp;</span></span></span></p>
B:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 逻辑独立性<span lang="EN-US"><o:p></o:p></span>
C:<p class="MsoNormal" style="TEXT-INDENT: 21pt; mso-char-indent-count: 2.0"><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;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></p>
D:&nbsp;&nbsp;<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>完整性<span lang="EN-US"><o:p></o:p></span>

&nbsp; <p class="MsoNormal"><span style="COLOR: black; FONT-FAMILY: 宋体">有两个实体集,并且它们之间存在着一个<span lang="EN-US">1</span>:<span lang="EN-US">1</span>联系,那么根据<span lang="EN-US">ER</span>模型转换成关系数据<span lang="EN-US"><o:p></o:p></span></span></p><p class="MsoNormal"><span lang="EN-US" style="COLOR: black; FONT-FAMILY: 宋体"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp; </span></span><span style="COLOR: black; FONT-FAMILY: 宋体">库的规则,这个<span lang="EN-US">ER</span>结构转换成表的个数为<span lang="EN-US"><o:p></o:p></span></span></p>
A:<p class="MsoNormal" style="TEXT-INDENT: 42pt; mso-char-indent-count: 4.0"><span style="COLOR: black; FONT-FAMILY: 宋体"><span lang="EN-US">1<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></span></p>
B:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span lang="EN-US">2<o:p></o:p></span>
C:<p class="MsoNormal" style="TEXT-INDENT: 42pt; mso-char-indent-count: 4.0"><span style="COLOR: black; FONT-FAMILY: 宋体"><span lang="EN-US">3<span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></span></p>
D:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span lang="EN-US">4<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">UNDO</span>处理<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;</span></span></span>
B:进行<span lang="EN-US">REDO</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;&nbsp;</span></span></p>
C:&nbsp;<span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt">执行<span lang="EN-US">COMMIT</span>操作<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;</span></span></span>
D:<span style="mso-spacerun: yes">&nbsp;</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"><span style="mso-spacerun: yes">&nbsp;&nbsp;</span><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;&nbsp; </span></span></p>
C:<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 style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span>
D:对数据的所有操作

&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"><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:<span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">PRIMARY KEY<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:<span lang="EN-US">NOT NULL<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:&nbsp;<span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">FOREIGN KEY<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>
D:<span lang="EN-US">FOREIGN KEY</span>&hellip;&hellip;<span lang="EN-US">REFERENCES<o:p></o:p></span>

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

&nbsp; <p class="MsoPlainText"><span lang="EN-US" style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">&nbsp;SQL</span><span style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">语言中,<span lang="EN-US">SELECT</span>语句的执行结果是<span lang="EN-US"><o:p></o:p></span></span></p>
A:<p class="MsoPlainText" style="TEXT-INDENT: 15.75pt; mso-char-indent-count: 1.5"><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 style="mso-spacerun: yes">&nbsp;&nbsp;&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;&nbsp;&nbsp;&nbsp;&nbsp;</span></span></span></p>
B:&nbsp;&nbsp;&nbsp; &nbsp;表<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><o:p></o:p></span><p class="MsoPlainText" style="TEXT-INDENT: 10.5pt; mso-char-indent-count: 1.0"><span lang="EN-US" style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'"><span style="mso-spacerun: yes">&nbsp;</span></span></p>
C:&nbsp;<span style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">元组<span lang="EN-US"><span style="mso-spacerun: yes">&nbsp;&nbsp;&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;&nbsp;&nbsp;&nbsp;</span></span></span>
D:&nbsp; 数据库

<p class="MsoNormal" style="TEXT-ALIGN: left" align="left"><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"><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">Response</span><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 style="mso-bidi-font-weight: bold">存取方法包括存储结构和检索机制两部分。</span><span lang="EN-US"><o:p></o:p></span></span></p>
A:错误
B:正确

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

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|Archiver|手机版|小黑屋|超前自学网 ( 皖ICP备20014425号-1 )|网站地图

GMT+8, 2025-5-2 02:04

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.. 技术支持 by 巅峰设计

快速回复 返回顶部 返回列表