|

 <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"> </span><span style="mso-spacerun: yes"> </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"> </span><span style="mso-spacerun: yes"> </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"> </span><span style="mso-spacerun: yes"> </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"> </span><span style="mso-spacerun: yes"> </span><span style="mso-spacerun: yes"> </span><span style="mso-spacerun: yes"> </span><span style="mso-spacerun: yes"> </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: <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"> </span><span style="mso-spacerun: yes"> </span></span></span></p>
B: 数据库管理系统<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"> </span></span></span></p>
D: 数据库系统
<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"> </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"> </span><span style="mso-spacerun: yes"> </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"> </span><span style="mso-spacerun: yes"> </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"> </span></span></span>
D: 面向对象模型
<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"> </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"> </span><span style="mso-spacerun: yes"> </span></span></span></p>
B: 逻辑独立性<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"> </span><span style="mso-spacerun: yes"> </span></span></span></p>
D: <span style="mso-spacerun: yes"> </span>完整性<span lang="EN-US"><o:p></o:p></span>
<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"> </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"> </span><span style="mso-spacerun: yes"> </span></span></span></p>
B: <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"> </span><span style="mso-spacerun: yes"> </span></span></span></p>
D: <span lang="EN-US">4<o:p></o:p></span>
<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"> </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"> </span><span style="mso-spacerun: yes"> </span><span style="mso-spacerun: yes"> </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"> </span></span></p>
C: <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"> </span><span style="mso-spacerun: yes"> </span></span></span>
D:<span style="mso-spacerun: yes"> </span>重新执行已登记的操作
<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"> </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"> </span><span style="mso-spacerun: yes"> </span><span style="mso-spacerun: yes"> </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"> </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"> </span><span style="mso-spacerun: yes"> </span></span></span>
D:对数据的所有操作
<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"> </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"> </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"> </span></span></p>
C: <span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">FOREIGN KEY<span style="mso-tab-count: 1"> </span></span></span>
D:<span lang="EN-US">FOREIGN KEY</span>……<span lang="EN-US">REFERENCES<o:p></o:p></span>
<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"> </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"> </span></span></span>
B: <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"> </span><span style="mso-spacerun: yes"> </span></span></p>
C: <span style="COLOR: black; FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt"><span lang="EN-US">WHERE<span style="mso-spacerun: yes"> </span></span></span>
D: <span lang="EN-US">GROUP BY<o:p></o:p></span>
<p class="MsoPlainText"><span lang="EN-US" style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'"> 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'"> </span><span style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">属性<span lang="EN-US"><span style="mso-spacerun: yes"> </span><span style="mso-spacerun: yes"> </span></span></span></p>
B: 表<span lang="EN-US"><span style="mso-spacerun: yes"> </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"> </span></span></p>
C: <span style="mso-hansi-font-family: 宋体; mso-bidi-font-family: 'Times New Roman'">元组<span lang="EN-US"><span style="mso-spacerun: yes"> </span><span style="mso-spacerun: yes"> </span></span></span>
D: 数据库
<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"> </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:正确
|
|