<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta name="generator" content="pdf2htmlEX">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css">
<link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css">
<link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/626da9f440256a40ce6554b2/raw.css">
<script src="https://static.pudn.com/base/js/compatibility.min.js"></script>
<script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script>
<script>
try{
pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});
}catch(e){}
</script>
<title></title>
</head>
<body>
<div id="sidebar" style="display: none">
<div id="outline">
</div>
</div>
<div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626da9f440256a40ce6554b2/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">数据库系统概论复习资料：</div><div class="t m0 x2 h3 y3 ff1 fs0 fc0 sc0 ls0 ws0">第一章<span class="sc1">：</span></div><div class="t m0 x2 h3 y4 ff1 fs0 fc0 sc1 ls0 ws0">一选择题：</div><div class="t m0 x2 h3 y5 ff2 fs0 fc0 sc1 ls0 ws0">1<span class="_ _0"></span><span class="ff1">．<span class="_ _0"></span>在<span class="_ _0"></span>数<span class="_ _0"></span>据<span class="_ _0"></span>管<span class="_ _0"></span>理<span class="_ _0"></span>技<span class="_ _0"></span>术<span class="_ _0"></span>的<span class="_ _0"></span>发<span class="_ _0"></span>展<span class="_ _0"></span>过<span class="_ _0"></span>程<span class="_ _0"></span>中<span class="_ _0"></span>，<span class="_ _0"></span>经<span class="_ _0"></span>历<span class="_ _0"></span>了<span class="_ _0"></span>人<span class="_ _0"></span>工<span class="_ _0"></span>管<span class="_ _1"></span>理<span class="_ _0"></span>阶<span class="_ _0"></span>段<span class="_ _0"></span>、<span class="_ _0"></span>文<span class="_ _0"></span>件<span class="_ _0"></span>系<span class="_ _0"></span>统<span class="_ _0"></span>阶<span class="_ _0"></span>段<span class="_ _0"></span>和<span class="_ _0"></span>数<span class="_ _0"></span>据<span class="_ _0"></span>库<span class="_ _0"></span>系<span class="_ _0"></span>统<span class="_ _0"></span>阶<span class="_ _0"></span>段<span class="_ _0"></span>。<span class="_ _0"></span>在<span class="_ _0"></span>这<span class="_ _1"></span>几<span class="_ _0"></span>个<span class="_ _0"></span>阶<span class="_ _0"></span>段<span class="_ _0"></span>中<span class="_ _0"></span>，<span class="_ _2"> </span><span class="fc1">数<span class="_ _0"></span>据<span class="_ _0"></span>独<span class="_ _0"></span>立<span class="_ _0"></span>性<span class="_ _0"></span>最<span class="_ _0"></span>高<span class="_ _0"></span>的<span class="_ _0"></span>是</span></span></div><div class="t m0 x2 h3 y6 ff1 fs0 fc1 sc1 ls0 ws0">阶段。 <span class="ff2">A</span>．数据库系统<span class="fc0"> <span class="ff2">B</span>．文件系统 <span class="ff2">C</span>．人工管理 <span class="ff2">D</span>．数据项管理 答案：<span class="_ _0"></span><span class="ff2">A</span></span></div><div class="t m0 x2 h3 y7 ff2 fs0 fc0 sc1 ls0 ws0">2<span class="ff1">．数据库的概念模型独立于 。</span><span class="fc1">A<span class="ff1">．具体的机器和<span class="_ _3"> </span></span>DBMS </span> B<span class="ff1">．</span>E-R<span class="_ _3"> </span><span class="ff1">图 </span>C<span class="ff1">．信息世界 </span>D<span class="ff1">．现实世界 答案：</span>A</div><div class="t m0 x2 h3 y8 ff2 fs0 fc0 sc1 ls0 ws0">3<span class="ff1">．数据库的基本特点是 。</span></div><div class="t m0 x2 h3 y9 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．</span>(1)<span class="ff1">数据可以共享</span>(<span class="ff1">或数据结构化</span>) (2)<span class="ff1">数据独立性 </span>(3)<span class="ff1">数据冗余大，易移植 </span>(4)<span class="ff1">统一管理和控制</span></div><div class="t m0 x2 h3 ya ff2 fs0 fc0 sc1 ls0 ws0"> B<span class="ff1">．</span><span class="fc1">(1)<span class="ff1">数据可以共享</span>(<span class="ff1">或数据结构化</span>) (2)<span class="ff1">数据独立性 </span>(3)<span class="ff1">数据冗余小，易扩充 </span>(4)<span class="ff1">统一管理和控制</span></span></div><div class="t m0 x2 h3 yb ff2 fs0 fc0 sc1 ls0 ws0"> C<span class="ff1">．</span>(1)<span class="ff1">数据可以共享</span>(<span class="ff1">或数据结构化</span>) (2)<span class="ff1">数据互换性 </span>(3)<span class="ff1">数据冗余小，易扩充 </span>(4)<span class="ff1">统一管理和控制</span></div><div class="t m0 x2 h3 yc ff2 fs0 fc0 sc1 ls0 ws0"> D<span class="ff1">．</span>(1)<span class="ff1">数据非结构化 </span>(2)<span class="ff1">数据独立性 </span>(3)<span class="ff1">数据冗余小，易扩充 <span class="_ _0"></span></span>(4)<span class="ff1">统一管理和控制 答案：</span>B</div><div class="t m0 x2 h3 yd ff2 fs0 fc0 sc1 ls0 ws0">4. <span class="ff1">是存储在计算机内有结构的数据的集合。 </span>A<span class="ff1">．数据库系统 </span><span class="fc1">B<span class="ff1">．数据库<span class="fc0"> </span></span></span>C<span class="ff1">．数据库管理系统<span class="_ _3"> </span></span>D<span class="ff1">．数据结构 答案：</span>B</div><div class="t m0 x2 h3 ye ff2 fs0 fc0 sc1 ls0 ws0">5<span class="ff1">．数据库中存储的是 。 </span>A<span class="ff1">．数据 </span>B<span class="_ _0"></span><span class="ff1">．数据模型 </span><span class="fc1">C<span class="ff1">．数据以及数据之间的联系<span class="fc0"> </span></span></span>D<span class="ff1">．信息 答案：</span>C</div><div class="t m0 x2 h3 yf ff2 fs0 fc0 sc1 ls0 ws0">6. <span class="ff1">数据库中，数据的物理独立性是指 。</span></div><div class="t m0 x2 h3 y10 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．数据库与数据库管理系统的相互独立 </span>B<span class="ff1">．用户程序与<span class="_ _3"> </span></span>DBMS<span class="_ _4"> </span><span class="ff1">的相互独立</span></div><div class="t m0 x2 h3 y11 ff2 fs0 fc0 sc1 ls0 ws0"> C<span class="ff1">．<span class="fc1">用户的应用程序与存储在磁盘上数据库中的数据是相互独立的</span> </span>.. D<span class="ff1">．应用程序与数据库中数据的逻辑结构相互独立 答案：</span>C</div><div class="t m0 x2 h3 y12 ff2 fs0 fc0 sc1 ls0 ws0">7. <span class="ff1">．数据库的特点之一是数据的共享，严格地讲，这里的数据共享是指 。</span></div><div class="t m0 x2 h3 y13 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．同一个应用中的多个程序共享一个数据集合 </span>B<span class="ff1">．多个用户、同一种语言共享数据</span></div><div class="t m0 x2 h3 y14 ff2 fs0 fc0 sc1 ls0 ws0"> C<span class="ff1">．多个用户共享一个数据文件 </span>D<span class="ff1">．<span class="fc1">多种应用、多种语言、多个用户相互覆盖地使用数据集合</span> 答案：</span>D</div><div class="t m0 x2 h3 y15 ff2 fs0 fc0 sc1 ls0 ws0">8.<span class="ff1">据库系统的核心是 。</span>A<span class="ff1">．数据库<span class="_ _4"> </span></span>B<span class="_ _0"></span><span class="ff1">．<span class="fc1">数据库管理系统</span> </span>C<span class="ff1">．数据模型 </span>D<span class="ff1">．软件工具 答案：</span>B</div><div class="t m0 x2 h3 y16 ff2 fs0 fc0 sc1 ls0 ws0">9. <span class="ff1">下述关于数据库系统的正确叙述是 。</span></div><div class="t m0 x2 h3 y17 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．<span class="fc1">数据库系统减少了数据冗余</span> </span>B<span class="ff1">．数据库系统避免了一切冗余 </span>C<span class="ff1">．数据库系统中数据的一致性是指数据类型一致</span></div><div class="t m0 x2 h3 y18 ff2 fs0 fc0 sc1 ls0 ws0"> D<span class="ff1">．数据库系统比文件系统能管理更多的数据 答案：</span>A</div><div class="t m0 x2 h3 y19 ff2 fs0 fc0 sc1 ls0 ws0">10. <span class="ff1">数将数据库的结构划分成多个层次，是为了提高数据库的 ① 和 ② 。</span></div><div class="t m0 x2 h3 y1a ff2 fs0 fc0 sc1 ls0 ws0"> ①A<span class="ff1">．数据独立性 </span>B<span class="ff1">．<span class="fc1">逻辑独立性</span> </span>C<span class="ff1">．管理规范性 </span>D<span class="ff1">．数据的共享</span></div><div class="t m0 x2 h3 y1b ff2 fs0 fc0 sc1 ls0 ws0"> ②A<span class="ff1">．数据独立性 </span>B<span class="ff1">．<span class="fc1">物理独立性</span> </span>C<span class="ff1">．逻辑独立性 </span>D<span class="ff1">．管理规范性 答案：①<span class="_ _3"> </span></span>B<span class="_ _0"></span> ②B</div><div class="t m0 x2 h3 y1c ff2 fs0 fc0 sc1 ls0 ws0">11. <span class="ff1">数据库</span>(DB)<span class="ff1">、数据库系统</span>(DBS)<span class="ff1">和数据库管理系统</span>(DBMS)<span class="ff1">三者之间的关系是答案：</span>A <span class="ff1">。</span></div><div class="t m0 x2 h3 y1d ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．</span><span class="fc1">DBS<span class="_ _4"> </span><span class="ff1">包括<span class="_ _4"> </span></span>DB<span class="_ _4"> </span><span class="ff1">和<span class="_ _4"> </span></span>DBMS<span class="_ _0"></span></span> B<span class="ff1">．</span>DDMS<span class="_ _4"> </span><span class="ff1">包括<span class="_ _3"> </span></span>DB<span class="_ _4"> </span><span class="ff1">和<span class="_ _4"> </span></span>DBS C<span class="ff1">．</span>DB<span class="_ _4"> </span><span class="ff1">包括<span class="_ _3"> </span></span>DB<span class="_ _5"></span>S<span class="_ _4"> </span><span class="ff1">和<span class="_ _4"> </span></span>DBMS <span class="_ _0"></span> D<span class="ff1">．</span>DBS<span class="_ _4"> </span><span class="ff1">就是<span class="_ _4"> </span></span>DB<span class="ff1">，也就是<span class="_ _4"> </span></span>DBMS</div><div class="t m0 x2 h3 y1e ff2 fs0 fc0 sc1 ls0 ws0">12. <span class="ff1">在数据库中，产生数据不一致的根本原因是 。</span></div><div class="t m0 x2 h3 y1f ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．数据存储量太大 </span>B<span class="ff1">．没有严格保护数据 </span>C<span class="ff1">．未对数据进行完整性控制 <span class="fc1"> <span class="ff2">D</span>．数据冗余 答案：<span class="ff2">D</span></span></span></div><div class="t m0 x2 h3 y20 ff2 fs0 fc0 sc1 ls0 ws0">13. <span class="ff1">数据库管理系统</span>(DBMS)<span class="ff1">是 </span>A<span class="ff1">．数学软件<span class="_ _4"> </span></span>B<span class="_ _0"></span><span class="ff1">．应用软件 </span>C<span class="ff1">．计算机辅助设计 </span><span class="fc1">D<span class="ff1">．系统软件 <span class="fc0"> 答案：</span></span></span>D</div><div class="t m0 x2 h3 y21 ff2 fs0 fc0 sc1 ls0 ws0">14. <span class="ff1">数据库管理系统</span>(DBMS)<span class="ff1">的主要功能是 </span>B <span class="ff1">。</span>A<span class="ff1">．修改数据库 </span>B<span class="ff1">．<span class="fc1">定义数据库 </span> </span>C<span class="_ _0"></span><span class="ff1">．应用数据库<span class="_ _4"> </span></span>D<span class="ff1">．保护数据库 </span></div><div class="t m0 x2 h3 y22 ff2 fs0 fc0 sc1 ls0 ws0">15. <span class="ff1">数据库系统的特点是 、数据独立、减少数据冗余、避免数据不一致和加强了数据保护。</span></div><div class="t m0 x2 h3 y23 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．<span class="fc1">数据共享 </span> </span>B<span class="ff1">．数据存储 </span>C<span class="ff1">．数据应用 </span>D<span class="ff1">．数据保密 答案：</span>A</div><div class="t m0 x2 h3 y24 ff2 fs0 fc0 sc1 ls0 ws0">16<span class="_ _4"> </span><span class="ff1">据库系统的最大特点是 。</span></div><div class="t m0 x2 h3 y25 ff2 fs0 fc1 sc1 ls0 ws0"> A<span class="ff1">．数据的三级抽象和二级独立性 <span class="fc0"> <span class="ff2">B</span>．数据共享性 <span class="ff2">C</span>．数据的结构化 <span class="_ _0"></span><span class="ff2">D</span>．数据独立性 答案：<span class="ff2">A</span></span></span></div><div class="t m0 x2 h3 y26 ff2 fs0 fc0 sc1 ls0 ws0">17. <span class="ff1">数据库管理系统能实现对数据库中数据的查询、插入、修改和删除等操作，这种功能称为 。</span></div><div class="t m0 x2 h3 y27 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．数据定义功能 </span>B<span class="ff1">．数据管理功能 </span>C<span class="ff1">．<span class="fc1">数据操纵功能</span> </span>D<span class="ff1">．数据控制功能 答案：</span>C</div><div class="t m0 x2 h3 y28 ff2 fs0 fc0 sc1 ls0 ws0">18. <span class="ff1">数据库管理系统是 。</span></div><div class="t m0 x2 h3 y29 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．操作系统的一部分 </span>B<span class="ff1">．<span class="fc1">在操作系统支持下的系统软件</span> </span>C<span class="ff1">．一种编译程序 </span>D<span class="ff1">．一种操作系统 答案：<span class="_ _0"></span></span>B</div><div class="t m0 x2 h3 y2a ff2 fs0 fc0 sc1 ls0 ws0">19.<span class="ff1">据库的三级模式结构中，<span class="fc1">描述数据库中全体数据的全局逻辑结构和特征的是</span>（）</span></div><div class="t m0 x2 h3 y2b ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．外模式 </span>B<span class="ff1">．内模式 </span>C<span class="ff1">．存储模式 </span>D<span class="ff1 fc1">．模式 <span class="fc0"> 答案：<span class="_ _0"></span></span></span>D</div><div class="t m0 x2 h3 y2c ff2 fs0 fc1 sc1 ls0 ws0">20<span class="_ _4"> </span><span class="ff1">据库系统的数据独立性是指 <span class="_ _6"></span> <span class="_ _7"> </span> <span class="ff2">B <span class="_ _8"></span><span class="ff1"> <span class="_ _9"> </span> 。 </span></span></span></div><div class="t m0 x2 h3 y2d ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．不会因为数据的变化而影响应用程序 </span><span class="fc1">B<span class="ff1">．不会因为系统数据存储结构与数据逻辑结构的变化而影响应用程序</span></span></div><div class="t m0 x2 h3 y2e ff2 fs0 fc0 sc1 ls0 ws0"> C<span class="ff1">．不会因为存储策略的变化而影响存储结构 </span>D<span class="ff1">．不会因为某些存储结构的变化而影响其他的存储结构 答案：</span>B</div><div class="t m0 x2 h3 y2f ff2 fs0 fc0 sc1 ls0 ws0">21.<span class="ff1">信息世界中的术语，与之对应的数据库术语为 </span>A<span class="ff1">．文件 </span>B<span class="ff1">．数据库 </span>C<span class="ff1">．字段 <span class="fc1"> <span class="ff2">D<span class="_ _0"></span></span>．记录 </span> 答案：</span>D</div><div class="t m0 x2 h3 y30 ff2 fs0 fc0 sc1 ls0 ws0">22<span class="_ _4"> </span><span class="ff1">次型、网状型和关系型数据库划分原则是 。</span></div><div class="t m0 x2 h3 y31 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．记录长度 </span>B<span class="ff1">．文件的大小 </span>C<span class="ff1">．联系的复杂程度 </span>D<span class="ff1">．<span class="fc1">数据之间的联系 </span> 答案：</span>D</div><div class="t m0 x2 h3 y32 ff2 fs0 fc0 sc1 ls0 ws0">23.<span class="ff1">传统的数据模型分类，数据库系统可以分为三种类型 。</span></div><div class="t m0 x2 h3 y33 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．大型、中型和小型 </span>B<span class="ff1">．西文、中文和兼容 </span>C<span class="ff1">．<span class="fc1">层次、网状和关系 </span> </span>D<span class="ff1">．数据、图<span class="ff3">形</span>和多<span class="ff3">媒</span>体 答案：</span>C</div><div class="t m0 x2 h3 y34 ff2 fs0 fc0 sc1 ls0 ws0">24. <span class="ff1">层次模型<span class="fc1">不能</span><span class="ff3">直接表示</span> </span>A<span class="ff1">． </span>1 <span class="ff1">：</span>1<span class="_ _4"> </span><span class="ff1">关系 </span>B<span class="_ _0"></span><span class="ff1">．</span>1 <span class="ff1">：</span>m<span class="_ _4"> </span><span class="ff1">关系 </span>C<span class="ff1">．<span class="fc1"> <span class="ff2">m </span>：<span class="ff2">n<span class="_ _3"> </span></span>关系 </span> </span>D<span class="ff1">．</span>1 <span class="ff1">：</span>1<span class="_ _4"> </span><span class="ff1">和<span class="_ _3"> </span></span>1 <span class="ff1">：</span>m<span class="_ _4"> </span><span class="ff1">关系 答案：</span>C</div><div class="t m0 x2 h3 y35 ff2 fs0 fc0 sc1 ls0 ws0">25. <span class="ff1">数据库技术的<span class="ff3">奠</span>基人之一<span class="_ _4"> </span></span><span class="fc1">E.F<span class="ff1">．</span>Codd<span class="_ _4"> </span></span><span class="ff3">从<span class="_ _3"> </span></span>1970<span class="_ _4"> </span><span class="ff3">年起<span class="ff1">发</span>表<span class="ff1">过多</span>篇<span class="ff1">论文，主要论述的是 。</span></span></div><div class="t m0 x2 h3 y36 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．层次数据模型 </span>B<span class="ff1">．网状数据模型 </span>C<span class="ff1">．<span class="fc1">关系数据模型</span> </span>D<span class="ff1">．<span class="ff3">面向</span>对象数据模型 答案：<span class="_ _0"></span></span>C</div><div class="t m0 x2 h3 y37 ff1 fs0 fc0 sc1 ls0 ws0">二、<span class="ff3">填空</span>题</div><div class="t m0 x2 h3 y38 ff2 fs0 fc0 sc1 ls0 ws0">1. <span class="ff1">数据管理技术经历了 人工管理 、 文件系统 和 数据库系统 三个阶段。 答案：①人工管理 ②文件系统 ②数据库系统</span></div><div class="t m0 x2 h3 y39 ff2 fs0 fc0 sc1 ls0 ws0">2. <span class="ff1 fc1">数据库是长<span class="ff3">期</span>存储在计算机内、有 <span class="ff3">组织</span>的、可共享的数据集合<span class="fc0">。 答案：①<span class="ff3">组织</span> ②共享</span></span></div><div class="t m0 x2 h3 y3a ff2 fs0 fc0 sc1 ls0 ws0">3<span class="ff1">．</span><span class="fc1">DBMS<span class="_ _4"> </span><span class="ff1">是指 <span class="ff3">它</span>是<span class="ff3">位</span>于 用户 和 <span class="ff3">③</span> 之间的一层管理软件<span class="fc0">。 答案：①数据库管理系统 ②用户 <span class="_ _0"></span><span class="ff3">③</span>操作系统</span></span></span></div><div class="t m0 x2 h3 y3b ff2 fs0 fc0 sc1 ls0 ws0">4. <span class="ff1">数据库管理系统的<span class="fc1">主要功能</span>有<span class="fc1">数据定义功能 </span> 、<span class="fc1">数据操纵功能 </span>、<span class="fc1">数据库的<span class="ff3">运</span>行管理</span>和<span class="fc1">数据库的<span class="ff3">建</span>立以及<span class="ff3">维</span>护</span>等<span class="_ _4"> </span></span>4<span class="_ _3"> </span><span class="ff1">个<span class="ff3">方面</span>。</span></div><div class="t m0 x3 h3 y3c ff1 fs0 fc0 sc1 ls0 ws0">答案：①数据定义功能 ②数据操纵功能</div><div class="t m0 x2 h3 y3d ff2 fs0 fc0 sc1 ls0 ws0">5. <span class="ff1 fc1">数据独立性</span><span class="ff3">又<span class="ff1">可分为<span class="fc1">逻辑数据独立性</span> 和 <span class="fc1">物理数据独立性</span>。 答案：①逻辑数据独立性 ②物理数据独立性</span></span></div><div class="t m0 x2 h3 y3e ff2 fs0 fc0 sc1 ls0 ws0">6. <span class="ff3">当<span class="ff1">数据的<span class="fc1">物理存储改变</span>了，<span class="fc1">应用程序不变</span>，而</span>由<span class="_ _4"> </span></span>DBMS<span class="_ _4"> </span><span class="ff3">处<span class="ff1">理这种改变，这是指数据的 <span class="_ _a"></span> <span class="_ _a"></span> <span class="fc1">物理独立性 <span class="_ _b"></span> <span class="_ _c"> </span> <span class="fc0"> <span class="_ _d"></span> <span class="_"> </span> 。 答案：物理独立性</span></span></span></span></div><div class="t m0 x2 h3 y3f ff2 fs0 fc0 sc1 ls0 ws0">7. <span class="ff1 fc1">数据模型<span class="fc0">是<span class="ff3">由</span></span>数据结构 、数据操作 和完整性<span class="ff3">约束</span> 三部分<span class="ff3">组</span>成<span class="fc0">的。 答案：①数据结构 ②数据操作 <span class="ff3">③</span>完整性<span class="ff3">约束</span></span></span></div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
</body>
</html>
<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626da9f440256a40ce6554b2/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x2 h3 y40 ff2 fs0 fc0 sc1 ls0 ws0">8. <span class="_ _e"></span> <span class="_ _e"></span> <span class="ff1 fc1">数据结构 <span class="_ _f"></span><span class="ff2"> <span class="_ _10"> </span> <span class="ff1">是对数据系统的<span class="ff3">静态</span>特性的描述<span class="fc0">，</span>数据操作 是对数据库系统的<span class="ff3">动态</span>特性的描述<span class="fc0">。 答案：①数据结构 ②数据操作</span></span></span></span></div><div class="t m0 x2 h3 y41 ff2 fs0 fc0 sc1 ls0 ws0">9. <span class="ff1 fc1">数据库体系结构<span class="ff3">按照</span> 模式 、 外模式 和 内模式 三级结构进行<span class="ff3">组织</span><span class="fc0">。 答案：①模式 ②外模式 <span class="_ _0"></span><span class="ff3">③</span>内模式</span></span></div><div class="t m0 x2 h3 y42 ff2 fs0 fc0 sc1 ls0 ws0">10. <span class="ff1">实体之间的联系可抽象为三类，<span class="ff3">它们</span>是 </span>1∶1 <span class="ff1">、 </span>1∶m <span class="ff1">和 </span>m∶n <span class="ff1">。 答案：①<span class="_ _4"> </span></span>1∶<span class="_ _0"></span>1 ②1∶m ②m∶n</div><div class="t m0 x2 h3 y43 ff2 fs0 fc0 sc1 ls0 ws0">11<span class="ff1">．<span class="fc1">数据冗余</span>可能<span class="ff3 fc1">导<span class="ff1">致的</span>问<span class="ff1">题</span></span>有 ① 和 ② 。 答案：①<span class="ff3 fc1">浪费<span class="ff1">存储</span>空<span class="ff1">间及修改</span>麻烦</span> ②<span class="ff3 fc1">潜<span class="ff1">在的数据不一致性</span></span></span></div><div class="t m0 x4 h3 y44 ff1 fs0 fc0 sc0 ls0 ws0">第一章<span class="ff3">补</span>充作<span class="ff3">业</span>部分：</div><div class="t m0 x2 h3 y45 ff3 fs0 fc0 sc1 ls0 ws0">假<span class="ff1">设</span>教<span class="ff1">学管理规定：</span></div><div class="t m0 x5 h3 y46 ff2 fs0 fc0 sc1 ls0 ws0">①<span class="_ _4"> </span><span class="ff1">一个学生可选修多<span class="ff3">门课</span>，一<span class="ff3">门课</span>有<span class="ff3">若干</span>学生选修<span class="ff3">；</span>②一个<span class="ff3">教师</span>可讲<span class="ff3">授</span>多<span class="ff3">门课</span>，一<span class="ff3">门课只</span>有一个<span class="ff3">教师</span>讲<span class="ff3">授；</span></span></div><div class="t m0 x5 h3 y47 ff2 fs0 fc0 sc1 ls0 ws0">③<span class="_ _4"> </span><span class="ff1">一个学生选修一<span class="ff3">门课</span>，<span class="ff3">仅</span>有一个成<span class="ff3">绩</span>。<span class="ff4"> </span>学生的<span class="ff3">属</span>性有学<span class="ff3">号</span>、学生<span class="ff3">姓名；教师</span>的<span class="ff3">属</span>性有<span class="ff3">教师</span>编<span class="ff3">号</span>，<span class="ff3">教师姓名；课</span>程的<span class="ff3">属</span>性有<span class="ff3">课</span>程<span class="ff3">号</span>、</span></div><div class="t m0 x2 h3 y48 ff3 fs0 fc0 sc1 ls0 ws0">课<span class="ff1">程</span>名<span class="ff1">。</span></div><div class="t m0 x5 h3 y49 ff1 fs0 fc0 sc1 ls0 ws0">要<span class="ff3">求</span>：根据上述语义<span class="ff3">画出<span class="_ _4"> </span><span class="ff4">ER<span class="_ _4"> </span></span></span>图，要<span class="ff3">求</span>在图中<span class="ff3">画出</span>实体的<span class="ff3">属</span>性<span class="ff3">并注明</span>联系的类型<span class="ff3">；</span></div><div class="t m0 x5 h3 y4a ff3 fs0 fc0 sc1 ls0 ws0">解<span class="ff1">答：</span></div><div class="t m0 x2 h3 y4b ff1 fs0 fc0 sc0 ls0 ws0">第<span class="_ _4"> </span><span class="ff5 sc1">2<span class="_ _4"> </span></span>章关系数据库</div><div class="t m0 x2 h3 y4c ff1 fs0 fc0 sc1 ls0 ws0">一、选择题</div><div class="t m0 x2 h3 y4d ff2 fs0 fc0 sc1 ls0 ws0">1<span class="ff1">、关系数据库管理系统应能实现的<span class="ff3 fc1">专门<span class="ff1">关系</span>运<span class="ff1">算</span></span>包括 。</span></div><div class="t m0 x2 h3 y4e ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．<span class="ff3">排</span>序、<span class="ff3">索引</span>、统计 </span>B<span class="ff1">．<span class="fc1">选择、<span class="ff3">投</span>影、<span class="ff3">连接</span> </span> </span>C<span class="ff1">．关联、更<span class="ff3">新</span>、<span class="ff3">排</span>序 </span>D<span class="ff1">．<span class="ff3">显示</span>、<span class="ff3">打印</span>、制<span class="ff3">表</span> 答案：</span>B</div><div class="t m0 x2 h3 y4f ff2 fs0 fc0 sc1 ls0 ws0">2<span class="ff1">、关系模型中，一个<span class="fc1">关<span class="ff3">键</span>字</span>是 。</span></div><div class="t m0 x5 h3 y50 ff2 fs0 fc0 sc1 ls0 ws0">A<span class="ff1">．可<span class="ff3">由</span>多个<span class="ff3">任意属</span>性<span class="ff3">组</span>成 </span>B<span class="ff1">．<span class="ff3">至</span>多<span class="ff3">由</span>一个<span class="ff3">属</span>性<span class="ff3">组</span>成 </span></div><div class="t m0 x6 h3 y51 ff2 fs0 fc0 sc1 ls0 ws0"> C<span class="ff1">．可<span class="ff3">由</span><span class="fc1">一个或多个其<span class="ff3">值</span>能<span class="ff3">惟</span>一<span class="ff3">标识该</span>关系模式中<span class="ff3">任何元组</span>的<span class="ff3">属</span>性<span class="ff3">组</span>成 </span> </span>D<span class="ff1">．以上<span class="ff3">都</span>不是 答案：</span>C</div><div class="t m0 x2 h3 y52 ff2 fs0 fc0 sc1 ls0 ws0">3<span class="ff1">、<span class="ff3">自然连接</span>是构成<span class="ff3">新</span>关系的有<span class="ff3">效方法</span>。一<span class="ff3">般情况</span>下，<span class="ff3">当</span>对关系<span class="_ _4"> </span></span>R<span class="_ _4"> </span><span class="ff1">和<span class="_ _3"> </span></span>S<span class="_ _4"> </span><span class="ff1">使用<span class="ff3">自然连接时</span>，要<span class="ff3">求<span class="_ _4"> </span></span></span>R<span class="_ _4"> </span><span class="ff1">和<span class="_ _3"> </span></span>S<span class="_ _4"> </span><span class="ff3">含<span class="ff1">有一个或多个共有的 。</span></span></div><div class="t m0 x2 h3 y53 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．<span class="ff3">元组</span> </span>B<span class="ff1">．行 </span>C<span class="ff1">．记录 </span>D<span class="ff1 fc1">．<span class="ff3">属</span>性 <span class="fc0"> 答案：<span class="_ _0"></span></span></span>D</div><div class="t m0 x2 h3 y54 ff2 fs0 fc0 sc1 ls0 ws0">4<span class="ff1">、关系<span class="ff3">运</span>算中<span class="ff3 fc1">花费时<span class="ff1">间可能最长</span></span>的<span class="ff3">运</span>算是 。 </span>A<span class="ff1">．<span class="ff3">投</span>影 </span>B<span class="_ _0"></span><span class="ff1">．选择 </span>C<span class="ff1 fc1">．<span class="ff3">笛卡尔积</span><span class="fc0"> </span></span>D<span class="ff1">．除 答案：</span>C</div><div class="t m0 x2 h3 y55 ff2 fs0 fc0 sc1 ls0 ws0">5<span class="ff1">．关系模式的<span class="ff3">任何属</span>性 </span>A<span class="ff1 fc1">．不可<span class="ff3">再</span>分 <span class="fc0"> </span></span>B<span class="ff1">．可<span class="ff3">再</span>分 </span>C<span class="ff1">．<span class="ff3">命名</span>在<span class="ff3">该</span>关系模式中可以不<span class="ff3">惟</span>一 <span class="_ _0"></span></span>D<span class="ff1">．以上<span class="ff3">都</span>不是 答案：</span>A</div><div class="t m0 x2 h3 y56 ff2 fs0 fc0 sc1 ls0 ws0">6<span class="ff1">．在<span class="fc1">关系<span class="ff3">代</span>数<span class="ff3">运</span></span>算中，<span class="ff3">五</span>种基本<span class="ff3">运</span>算为 。</span></div><div class="t m0 x5 h3 y57 ff2 fs0 fc0 sc1 ls0 ws0">A<span class="ff1">．<span class="ff3">并</span>、<span class="ff3">差</span>、选择、<span class="ff3">投</span>影、<span class="ff3">自然连接</span> </span>B<span class="ff1">．<span class="ff3">并</span>、<span class="ff3">差</span>、<span class="ff3">交</span>、选择、<span class="ff3">投</span>影 </span></div><div class="t m0 x5 h3 y58 ff2 fs0 fc0 sc1 ls0 ws0">C<span class="ff1">．<span class="ff3 fc1">并<span class="ff1">、</span>差<span class="ff1">、选择、</span>投<span class="ff1">影、</span>乘积</span> </span>D<span class="ff1">．<span class="ff3">并</span>、<span class="ff3">差</span>、<span class="ff3">交</span>、选择、<span class="ff3">乘积</span> 答案：</span>C</div><div class="t m0 x2 h3 y59 ff2 fs0 fc0 sc1 ls0 ws0">7<span class="ff1">、设有关系<span class="_ _4"> </span></span>R<span class="ff1">，<span class="ff3">按条</span>件<span class="_ _4"> </span></span>f<span class="_ _3"> </span><span class="ff1">对关系<span class="_ _4"> </span></span>R<span class="_ _4"> </span><span class="ff1">进行选择，正确的是 </span>A<span class="ff1">．</span>R<span class="ff6">´</span>R B<span class="ff1">．</span>R <span class="ff6">w<span class="_ _11"></span>v<span class="ff2"> R C<span class="ff1">． </span></span><span class="fc1">s<span class="ff2">f(R)<span class="fc0"> D<span class="ff1">．</span></span></span></span>P<span class="ff2">f<span class="_ _0"></span>(R) <span class="ff1">答案：</span>C</span></span></div><div class="t m0 x2 h3 y5a ff2 fs0 fc0 sc1 ls0 ws0">8<span class="ff1">、<span class="ff3">如</span>图<span class="ff3">所示</span>，<span class="ff3">两</span>个关系<span class="_ _4"> </span></span>R1<span class="_ _4"> </span><span class="ff1">和<span class="_ _3"> </span></span>R2<span class="ff1">，<span class="ff3">它们</span>进行 <span class="ff3">运</span>算<span class="ff3">后得到<span class="_ _4"> </span></span></span>R3<span class="ff1">。</span></div><div class="t m0 x7 h4 y5b ff2 fs0 fc0 sc1 ls0 ws0">R1</div><div class="t m0 x8 h4 y5c ff2 fs0 fc0 sc1 ls0 ws0">R3</div><div class="t m0 x9 h3 y5d ff2 fs0 fc0 sc1 ls0 ws0"> <span class="_ _2"> </span> <span class="_ _12"> </span> <span class="_ _12"> </span> <span class="_ _13"></span>A<span class="_ _12"> </span><span class="ff1">．<span class="_ _14"> </span><span class="ff3">交<span class="_ _15"> </span></span></span>B<span class="_ _0"></span><span class="ff1">．<span class="_ _0"></span><span class="ff3">并<span class="_ _1"></span></span> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _1"></span></span>C<span class="_ _1"></span><span class="ff1">．</span></div><div class="t m0 x9 h3 y5e ff3 fs0 fc0 sc1 ls0 ws0">笛<span class="_ _16"> </span>卡<span class="_ _16"> </span>尔<span class="_ _14"> </span>积<span class="_ _13"> </span><span class="ff1"> <span class="_ _13"> </span> <span class="_ _13"> </span> <span class="_ _13"> </span> <span class="_ _13"> </span> <span class="_ _13"> </span> <span class="_ _13"> </span> <span class="_ _13"> </span> <span class="_ _17"> </span><span class="ff2">D<span class="_ _18"> </span></span>．<span class="_ _18"> </span></span><span class="fc1">连<span class="_ _18"> </span>接</span></div><div class="t m0 x2 h3 y5f ff1 fs0 fc0 sc1 ls0 ws0">答案：<span class="ff2">D</span></div><div class="t m0 x2 h3 y60 ff1 fs0 fc0 sc1 ls0 ws0">二、<span class="ff3">填空</span>题</div><div class="t m0 x2 h3 y61 ff2 fs0 fc0 sc1 ls0 ws0">1<span class="ff1">、一个<span class="fc1">关系模式</span>的<span class="fc1">定义格式</span>为 。 答案：<span class="fc1">关系<span class="ff3">名<span class="ff2">(</span>属</span>性<span class="ff3">名<span class="_ _4"> </span><span class="ff2">1<span class="_ _0"></span></span></span>，<span class="ff3">属</span>性<span class="ff3">名<span class="_ _4"> </span><span class="ff2">2</span></span>，<span class="ff3">…</span>，<span class="ff3">属</span>性<span class="ff3">名<span class="_ _4"> </span><span class="ff2">n)</span></span></span></span></div><div class="t m0 x2 h3 y62 ff2 fs0 fc0 sc1 ls0 ws0">2<span class="ff1">、．一个关系模式的定义主要包括 关系<span class="ff3">名</span> 、<span class="ff3">属</span>性<span class="ff3">名</span> 、 <span class="ff3">属</span>性类型 <span class="_ _0"></span>、</span></div><div class="t m0 x2 h3 y63 ff2 fs0 fc0 sc1 ls0 ws0"> <span class="ff3">属<span class="ff1">性长度 和关</span>键<span class="ff1">字 。 答案：①关系</span>名<span class="ff1"> ②</span>属<span class="ff1">性</span>名<span class="ff1"> </span>③属<span class="ff1">性类型 <span class="_ _0"></span></span>④属<span class="ff1">性长度 </span>⑤<span class="ff1">关</span>键<span class="ff1">字</span></span></div><div class="t m0 x2 h3 y64 ff2 fs0 fc0 sc1 ls0 ws0">3<span class="ff1">、．关系<span class="ff3">代</span>数<span class="ff3">运</span>算中，<span class="fc1">传统的集合<span class="ff3">运</span>算</span>有① 、②、<span class="ff3">③</span> 和 <span class="ff3">④</span> 。 答案：①<span class="ff3">笛卡尔积</span> ②<span class="ff3">并</span> <span class="ff3">③交</span> <span class="ff3">④差</span></span></div><div class="t m0 x2 h3 y65 ff2 fs0 fc0 sc1 ls0 ws0">4<span class="ff1">、关系<span class="ff3 fc1">代<span class="ff1">数</span>运</span>算中，基本的<span class="ff3">运</span>算是 ① 、 ② 、<span class="ff3">③</span>、<span class="ff3">④</span> 和<span class="ff3">⑤</span>。 答案：①<span class="ff3">并</span> ②<span class="ff3">差</span> <span class="ff3">③笛卡尔积</span> <span class="ff3">④投</span>影 <span class="_ _0"></span><span class="ff3">⑤</span>选择</span></div><div class="t m0 x2 h3 y66 ff2 fs0 fc0 sc1 ls0 ws0">5<span class="ff1">、关系<span class="ff3">代</span>数<span class="ff3">运</span>算中，<span class="ff3 fc1">专门<span class="ff1">的关系</span><span class="fc0">运</span></span>算有 选择 、 <span class="ff3">投</span>影 和 <span class="ff3">连接</span> <span class="_ _0"></span>。 答案：①选择 ②<span class="ff3">投</span>影 <span class="ff3">③连接</span></span></div><div class="t m0 x2 h3 y67 ff2 fs0 fc0 sc1 ls0 ws0">6<span class="ff1">、关系数据库中<span class="fc1">基于数学上<span class="ff3">两</span>类<span class="ff3">运</span>算</span>是<span class="fc1">关系<span class="ff3">代</span>数</span> 和<span class="fc1">关系<span class="ff3">演</span>算 <span class="_ _e"></span> <span class="_ _a"></span> <span class="fc0"> <span class="_ _19"></span> <span class="_ _1a"> </span> 。答案：①关系<span class="ff3">代</span>数 ②关系<span class="ff3">演</span>算</span></span></span></div></div><div class="t m0 xa h4 y68 ff2 fs0 fc0 sc1 ls0 ws0">A<span class="_ _1b"> </span>B<span class="_ _1b"> </span>C<span class="_ _1b"> </span>D<span class="_ _1c"> </span>E</div><div class="t m0 xa h4 y69 ff2 fs0 fc0 sc1 ls0 ws0">A</div><div class="t m0 xa h4 y6a ff2 fs0 fc0 sc1 ls0 ws0">C</div><div class="t m0 xa h4 y6b ff2 fs0 fc0 sc1 ls0 ws0">C</div><div class="t m0 xb h4 y69 ff2 fs0 fc0 sc1 ls0 ws0">1</div><div class="t m0 xb h4 y6a ff2 fs0 fc0 sc1 ls0 ws0">1</div><div class="t m0 xb h4 y6b ff2 fs0 fc0 sc1 ls0 ws0">2</div><div class="t m0 xc h4 y69 ff2 fs0 fc0 sc1 ls0 ws0">X</div><div class="t m0 xc h4 y6a ff2 fs0 fc0 sc1 ls0 ws0">Y</div><div class="t m0 xc h4 y6b ff2 fs0 fc0 sc1 ls0 ws0">y</div><div class="t m0 xd h4 y69 ff2 fs0 fc0 sc1 ls0 ws0">M</div><div class="t m0 xd h4 y6a ff2 fs0 fc0 sc1 ls0 ws0">M</div><div class="t m0 xd h4 y6b ff2 fs0 fc0 sc1 ls0 ws0">N</div><div class="t m0 xe h4 y69 ff2 fs0 fc0 sc1 ls0 ws0">I</div><div class="t m0 xe h4 y6a ff2 fs0 fc0 sc1 ls0 ws0">I</div><div class="t m0 xe h4 y6b ff2 fs0 fc0 sc1 ls0 ws0">J</div><div class="t m0 xf h4 y6c ff2 fs0 fc0 sc1 ls0 ws0">A<span class="_ _1b"> </span>B<span class="_ _1b"> </span>C</div><div class="t m0 xf h4 y6d ff2 fs0 fc0 sc1 ls0 ws0">A</div><div class="t m0 xf h4 y6e ff2 fs0 fc0 sc1 ls0 ws0">C</div><div class="t m0 xf h4 y6f ff2 fs0 fc0 sc1 ls0 ws0">D</div><div class="t m0 x10 h4 y6d ff2 fs0 fc0 sc1 ls0 ws0">1</div><div class="t m0 x10 h4 y6e ff2 fs0 fc0 sc1 ls0 ws0">2</div><div class="t m0 x10 h4 y6f ff2 fs0 fc0 sc1 ls0 ws0">1</div><div class="t m0 x11 h4 y6d ff2 fs0 fc0 sc1 ls0 ws0">X</div><div class="t m0 x11 h4 y6e ff2 fs0 fc0 sc1 ls0 ws0">Y</div><div class="t m0 x11 h4 y6f ff2 fs0 fc0 sc1 ls0 ws0">y</div><div class="t m0 x12 h4 y70 ff2 fs0 fc0 sc1 ls0 ws0">D<span class="_ _1c"> </span>E<span class="_ _1c"> </span>M</div><div class="t m0 x12 h4 y71 ff2 fs0 fc0 sc1 ls0 ws0">1</div><div class="t m0 x12 h4 y72 ff2 fs0 fc0 sc1 ls0 ws0">2</div><div class="t m0 x12 h4 y73 ff2 fs0 fc0 sc1 ls0 ws0">5</div><div class="t m0 x13 h4 y71 ff2 fs0 fc0 sc1 ls0 ws0">M</div><div class="t m0 x13 h4 y72 ff2 fs0 fc0 sc1 ls0 ws0">N</div><div class="t m0 x13 h4 y73 ff2 fs0 fc0 sc1 ls0 ws0">M</div><div class="t m0 x14 h4 y71 ff2 fs0 fc0 sc1 ls0 ws0">I</div><div class="t m0 x14 h4 y72 ff2 fs0 fc0 sc1 ls0 ws0">J</div><div class="t m0 x15 h4 y73 ff2 fs0 fc0 sc1 ls0 ws0">K</div><div class="c x0 y1 w2 h2"><div class="t m0 x16 h5 y74 ff1 fs1 fc0 sc1 ls0 ws0">成</div><div class="t m0 x16 h6 y75 ff3 fs1 fc0 sc1 ls0 ws0">绩</div><div class="t m0 x17 h6 y76 ff3 fs1 fc0 sc1 ls0 ws0">教<span class="_ _1d"> </span>师</div><div class="t m0 x17 h5 y77 ff1 fs1 fc0 sc1 ls0 ws0">编<span class="ff3">号</span></div><div class="t m0 x18 h6 y78 ff3 fs1 fc0 sc1 ls0 ws0">教<span class="_ _1d"> </span>师</div><div class="t m0 x18 h6 y79 ff3 fs1 fc0 sc1 ls0 ws0">姓名</div><div class="t m0 x19 h3 y7a ff1 fs0 fc0 sc1 ls0 ws0">学生</div><div class="t m0 x1a h5 y7b ff1 fs1 fc0 sc1 ls0 ws0">选</div><div class="t m0 x1a h5 y7c ff1 fs1 fc0 sc1 ls0 ws0">修</div><div class="t m0 x1b h7 y7d ff2 fs1 fc0 sc1 ls0 ws0">m</div><div class="t m0 x1c h3 y7e ff3 fs0 fc0 sc1 ls0 ws0">课<span class="ff1">程</span></div><div class="t m0 x1c h8 y7f ff3 fs0 fc0 sc1 ls0 ws0">教师</div><div class="t m0 x1d h5 y80 ff1 fs1 fc0 sc1 ls0 ws0">讲</div><div class="t m0 x1d h6 y81 ff3 fs1 fc0 sc1 ls0 ws0">授</div><div class="t m0 x1e h7 y7d ff2 fs1 fc0 sc1 ls0 ws0">n</div><div class="t m0 x1f h7 y82 ff2 fs1 fc0 sc1 ls0 ws0">n</div><div class="t m0 x1f h7 y83 ff2 fs1 fc0 sc1 ls0 ws0">1</div><div class="t m0 x20 h9 y84 ff1 fs2 fc0 sc1 ls0 ws0">学</div><div class="t m0 x20 ha y85 ff3 fs2 fc0 sc1 ls0 ws0">号</div><div class="t m0 x20 hb y86 ff3 fs3 fc0 sc1 ls0 ws0">姓</div><div class="t m0 x20 hb y87 ff3 fs3 fc0 sc1 ls0 ws0">名</div><div class="t m0 x21 h6 y88 ff3 fs1 fc0 sc1 ls0 ws0">课</div><div class="t m0 x21 h5 y89 ff1 fs1 fc0 sc1 ls0 ws0">程</div><div class="t m0 x21 h6 y8a ff3 fs1 fc0 sc1 ls0 ws0">号</div><div class="t m0 x22 h6 y88 ff3 fs1 fc0 sc1 ls0 ws0">课</div><div class="t m0 x22 h5 y89 ff1 fs1 fc0 sc1 ls0 ws0">程</div><div class="t m0 x22 h6 y8a ff3 fs1 fc0 sc1 ls0 ws0">名</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/626da9f440256a40ce6554b2/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x2 h3 y8b ff2 fs0 fc0 sc1 ls0 ws0">7<span class="ff1">、．<span class="ff3">已知<span class="_ _0"></span></span>系</span>(<span class="ff1">系<span class="_ _0"></span>编<span class="ff3">号</span>，系<span class="ff3">名</span>称<span class="_ _0"></span>，系主<span class="ff3">任</span>，<span class="ff3">电<span class="_ _0"></span>话</span>，地点<span class="_ _13"></span></span>)<span class="ff1">和学生</span>(<span class="ff1">学<span class="ff3">号<span class="_ _0"></span></span>，<span class="ff3">姓名</span>，性<span class="ff3">别<span class="_ _0"></span></span>，入学<span class="ff3">日<span class="_ _0"></span>期</span>，<span class="ff3">专业</span>，系<span class="_ _0"></span>编<span class="ff3">号<span class="_ _13"></span></span></span>)<span class="ff3">两<span class="ff1">个关系，系关<span class="_ _0"></span>系的主关</span>键</span></div><div class="t m0 x2 h3 y8c ff1 fs0 fc0 sc1 ls0 ws0">字是 ① ，系关系的外关<span class="ff3">键</span>字 ② ，学生关系的主关<span class="ff3">键</span>字是 <span class="ff3">③</span> ，外关<span class="ff3">键</span>字 <span class="ff3">④</span> 答案：①系编<span class="ff3">号</span> ②<span class="ff3">无</span> <span class="ff3">③</span>学<span class="ff3">号</span> <span class="ff3">④</span>系编<span class="ff3">号</span></div><div class="t m0 x2 h3 y8d ff1 fs0 fc0 sc1 ls0 ws0">三、应用题：</div><div class="t m0 x23 h3 y8e ff1 fs0 fc0 sc1 ls0 ws0">关系<span class="_ _4"> </span><span class="ff2">R<span class="_ _4"> </span></span>和<span class="_ _3"> </span><span class="ff2">S<span class="_ _4"> </span><span class="ff3">如</span></span>下图<span class="ff3">所示</span>，<span class="ff3">试</span>计算<span class="_ _4"> </span><span class="ff2">R÷S</span>。</div><div class="t m0 x24 h3 y8f ff1 fs0 fc0 sc0 ls0 ws0">第<span class="_ _4"> </span><span class="ff5 sc1">3<span class="_ _4"> </span></span>章关系数据库<span class="ff3">标准</span>语言<span class="_ _3"> </span><span class="ff5 sc1">SQL</span></div><div class="t m0 x2 h3 y90 ff1 fs0 fc0 sc1 ls0 ws0">一、选择题</div><div class="t m0 x2 h3 y91 ff2 fs0 fc0 sc1 ls0 ws0">1<span class="ff1">、</span>SQL<span class="_ _4"> </span><span class="ff1">语言是 <span class="_ _0"></span>的语言，易学习。</span></div><div class="t m0 x2 h3 y92 ff2 fs0 fc0 sc1 ls0 ws0"> <span class="_ _0"></span> <span class="_ _0"></span>A<span class="_ _0"></span><span class="ff1">．过<span class="_ _0"></span>程化<span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _1"></span></span>B<span class="_ _0"></span><span class="ff1">．<span class="fc1">非<span class="_ _0"></span>过程<span class="_ _0"></span>化<span class="_ _0"></span></span> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span></span>C<span class="ff1">．<span class="_ _0"></span>格式<span class="_ _0"></span>化 <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _1"></span></span>D<span class="ff1">．<span class="_ _0"></span><span class="ff3">导航<span class="_ _0"></span></span>式 <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span>答案<span class="_ _0"></span>：<span class="_ _1e"> </span></span>B</div><div class="t m0 x2 h3 y93 ff2 fs0 fc0 sc1 ls0 ws0">2<span class="ff1">、</span>SQL<span class="_ _4"> </span><span class="ff1">语言是 语言。</span></div><div class="t m0 x2 h3 y94 ff2 fs0 fc0 sc1 ls0 ws0"> <span class="_ _0"></span> <span class="_ _0"></span> A<span class="_ _1"></span><span class="ff1">．<span class="_ _0"></span>层<span class="_ _0"></span>次数<span class="_ _0"></span>据<span class="_ _0"></span>库 <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _13"></span></span>B<span class="ff1">．网<span class="_ _0"></span><span class="ff3">络<span class="_ _0"></span></span>数<span class="_ _0"></span>据库<span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _13"></span></span>C<span class="ff1">．<span class="fc1">关<span class="_ _0"></span>系<span class="_ _0"></span>数据<span class="_ _0"></span>库<span class="_ _1"></span></span> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span></span>D<span class="_ _0"></span><span class="ff1">．<span class="_ _0"></span>非<span class="_ _0"></span>数<span class="_ _1f"> </span>据库 答案：</span>C</div><div class="t m0 x2 h3 y95 ff2 fs0 fc0 sc1 ls0 ws0">3<span class="ff1">、</span>SQL<span class="_ _4"> </span><span class="ff1">语言具有 <span class="_ _0"></span>的功能。</span></div><div class="t m0 x2 h3 y96 ff2 fs0 fc0 sc1 ls0 ws0"> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span> A<span class="_ _0"></span><span class="ff1">．<span class="_ _0"></span>关<span class="_ _0"></span>系<span class="_ _0"></span>规<span class="_ _0"></span>范<span class="_ _0"></span>化、<span class="_ _0"></span>数<span class="_ _0"></span>据<span class="_ _0"></span>操<span class="_ _0"></span>纵<span class="_ _0"></span>、数<span class="_ _0"></span>据<span class="_ _0"></span>控<span class="_ _0"></span>制<span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _1"></span></span>B<span class="_ _0"></span><span class="ff1">．<span class="_ _0"></span><span class="fc1">数据<span class="_ _0"></span>定<span class="_ _0"></span>义<span class="_ _0"></span>、<span class="_ _0"></span>数<span class="_ _0"></span>据<span class="_ _0"></span>操<span class="_ _1f"> </span>纵、数据控制</span></span></div><div class="t m0 x2 h3 y97 ff2 fs0 fc0 sc1 ls0 ws0"> <span class="_ _0"></span> <span class="_ _0"></span> C<span class="_ _1"></span><span class="ff1">．数<span class="_ _0"></span>据<span class="_ _0"></span>定义<span class="_ _0"></span>、<span class="_ _0"></span>关系<span class="_ _0"></span>规<span class="_ _0"></span>范<span class="_ _0"></span>化、<span class="_ _0"></span>数<span class="_ _0"></span>据控<span class="_ _0"></span>制<span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _0"></span> <span class="_ _13"></span></span>D<span class="ff1">．<span class="_ _0"></span>数据<span class="_ _0"></span>定<span class="_ _0"></span>义、<span class="_ _0"></span>关<span class="_ _0"></span>系<span class="_ _0"></span>规<span class="_ _1e"> </span>范化、数据操纵 答案：</span>B</div><div class="t m0 x2 h3 y98 ff2 fs0 fc0 sc1 ls0 ws0">4<span class="ff1">、</span>SQL<span class="_ _4"> </span><span class="ff1">语言具有<span class="ff3">两</span>种使用<span class="ff3">方</span>式，分<span class="ff3">别</span>称为<span class="ff3">交</span>互式<span class="_ _4"> </span></span>SQL<span class="_ _3"> </span><span class="ff1">和 。</span></div><div class="t m0 x2 h3 y99 ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．提<span class="ff3">示</span>式<span class="_ _4"> </span></span>SQL B<span class="ff1">．多用户<span class="_ _4"> </span></span>SQL <span class="_ _0"></span> C<span class="ff1">．<span class="ff3 fc1">嵌<span class="ff1">入式<span class="_ _4"> </span><span class="ff2">SQL </span></span></span></span> D<span class="ff1">．<span class="ff3">解释</span>式<span class="_ _3"> </span></span>SQL <span class="ff1">答案：</span>C</div><div class="t m0 x2 h3 y9a ff2 fs0 fc0 sc1 ls0 ws0">5<span class="_"> </span><span class="ff1">、<span class="_ _12"> </span><span class="ff3">假<span class="_ _12"> </span></span>定<span class="_"> </span>学<span class="_"> </span>生<span class="_"> </span>关<span class="_"> </span>系<span class="_"> </span>是<span class="_ _20"> </span></span>S(S#<span class="_"> </span><span class="ff1">，<span class="_"> </span></span>SNAM<span class="_ _5"></span>E<span class="_"> </span><span class="ff1">，<span class="_"> </span></span>SEX<span class="_ _12"> </span><span class="ff1">，<span class="_"> </span></span>AGE)<span class="_ _12"> </span><span class="ff1">，<span class="_"> </span><span class="ff3">课<span class="_ _12"> </span></span>程<span class="_"> </span>关<span class="_"> </span>系<span class="_"> </span>是<span class="_ _20"> </span></span>C(C#<span class="_"> </span><span class="ff1">，<span class="_"> </span></span>CNA<span class="_ _5"></span>ME<span class="_"> </span><span class="ff1">，<span class="_"> </span></span>TEA<span class="_ _5"></span>CHER)<span class="_"> </span><span class="ff1">，<span class="_"> </span>学<span class="_"> </span>生<span class="_ _12"> </span>选<span class="_"> </span><span class="ff3">课<span class="_ _12"> </span></span>关<span class="_"> </span>系<span class="_"> </span>是</span></div><div class="t m0 x2 h3 y9b ff2 fs0 fc0 sc1 ls0 ws0">SC(S#<span class="ff1">，</span>C#<span class="ff1">，</span>GR<span class="_ _5"></span>ADE)<span class="ff1">。</span></div><div class="t m0 x2 h3 y9c ff2 fs0 fc0 sc1 ls0 ws0"> <span class="ff1">要查<span class="ff3">找</span>选修<span class="ff3">“</span></span>COMPUTER”<span class="ff3">课<span class="ff1">程的</span>“女”<span class="ff1">学生</span>姓名<span class="ff1">，将</span>涉<span class="ff1">及</span>到<span class="ff1">关系 。</span></span></div><div class="t m0 x2 h3 y9d ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．</span>S B<span class="ff1">．</span>SC<span class="ff1">，</span>C C<span class="ff1">．</span>S<span class="ff1">，</span>SC D<span class="ff1">．</span><span class="fc1">S<span class="ff1">，</span>C<span class="ff1">，</span>SC </span> <span class="ff1">答案：</span>D</div><div class="t m0 x2 h3 y9e ff2 fs0 fc0 sc1 ls0 ws0">6<span class="ff1">、<span class="ff3">如</span>下<span class="ff3">面</span>的数据库的<span class="ff3">表</span>中，<span class="ff3">若职</span>工<span class="ff3">表</span>的主关<span class="ff3">键</span>字是<span class="ff3">职</span>工<span class="ff3">号</span>，部<span class="ff3">门表</span>的主关<span class="ff3">键</span>字是部<span class="ff3">门号</span>，</span>SQL<span class="_ _4"> </span><span class="ff1">操作 <span class="fc1">不能<span class="ff3">执</span>行</span>。</span></div><div class="t m0 x2 h3 y9f ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1">．<span class="ff3">从职</span>工<span class="ff3">表</span>中删除行</span>(‘025’<span class="ff1">，<span class="ff3">‘王芳’</span>，<span class="ff3">‘<span class="_ _20"> </span></span></span>03’<span class="ff1">，</span>720) B<span class="ff1">．<span class="fc1">将行<span class="ff2">(‘005</span>，<span class="ff3">’</span>，<span class="ff3">‘乔兴’</span>，<span class="ff3">‘<span class="_ _20"> </span><span class="ff2">04’</span></span>，<span class="ff2">750)</span>插入<span class="ff3">到职</span>工<span class="ff3">表</span>中</span></span></div><div class="t m0 x2 h3 ya0 ff2 fs0 fc0 sc1 ls0 ws0"> C<span class="ff1">．将<span class="ff3">职</span>工<span class="ff3">号</span>为，<span class="ff3">‘</span></span>001’<span class="ff1">的工资改为<span class="_ _4"> </span></span>700 D<span class="ff1">．将<span class="ff3">职</span>工<span class="ff3">号</span>为，<span class="ff3">’</span></span>038’<span class="ff1">的部<span class="ff3">门号</span>改为<span class="ff3">‘</span></span>03’ <span class="_ _0"></span><span class="ff1">答案：</span>B </div><div class="t m0 x2 h3 ya1 ff2 fs0 fc0 sc1 ls0 ws0">7<span class="ff1">、<span class="ff3">若</span>用<span class="ff3">如</span>下的<span class="_ _4"> </span></span>SQL<span class="_ _4"> </span><span class="ff1">语<span class="ff3">句创建</span>一个<span class="_ _3"> </span></span>student<span class="_ _4"> </span><span class="ff3">表<span class="ff1">：</span></span></div><div class="t m0 x2 h3 ya2 ff2 fs0 fc0 sc1 ls0 ws0"> CREA<span class="_ _21"></span>TE T<span class="_ _21"></span>ABLE student(NO C(4) <span class="fc1">NOT NULL</span><span class="ff1">，</span></div><div class="t m0 x2 h3 ya3 ff2 fs0 fc0 sc1 ls0 ws0"> NAME C(8) <span class="fc1">NOT NULL</span><span class="ff1">，</span></div><div class="t m0 x2 h3 ya4 ff2 fs0 fc0 sc1 ls0 ws0"> SEX <span class="fc1">C</span>(2)<span class="ff1">，</span></div><div class="t m0 x2 h4 ya5 ff2 fs0 fc0 sc1 ls0 ws0"> AGE N(<span class="_ _5"></span>2))</div><div class="t m0 x2 h3 ya6 ff2 fs0 fc0 sc1 ls0 ws0"> <span class="ff1">可以插入<span class="ff3">到<span class="_ _4"> </span></span></span>student<span class="_ _4"> </span><span class="ff3">表<span class="ff1">中的是 <span class="_ _0"></span>。</span></span></div><div class="t m0 x5 h3 ya7 ff2 fs0 fc0 sc1 ls0 ws0">A<span class="ff1">．</span>(‘1031’<span class="ff1">，<span class="ff3">‘曾华’</span>，<span class="ff3">男</span>，<span class="_ _20"> </span></span>23) <span class="fc1"> B<span class="ff1">．</span>(‘1031’<span class="ff1">，<span class="ff3">‘曾华’</span>，<span class="_ _20"> </span></span>NULL<span class="_ _0"></span><span class="ff1">，</span>NULL)</span></div><div class="t m0 x25 h3 ya8 ff2 fs0 fc0 sc1 ls0 ws0"> C<span class="ff1">．</span>(NULL<span class="ff1">，<span class="ff3">‘曾华’</span>，<span class="ff3">‘男’</span>，<span class="ff3">‘<span class="_ _20"> </span></span></span>23’) D<span class="ff1">．</span>(‘1031’<span class="ff1">，</span>NULL<span class="ff1">，<span class="ff3">‘男’</span>，<span class="_ _20"> </span></span>23) <span class="_ _0"></span><span class="ff1">答案：</span>B</div><div class="t m0 x2 h3 ya9 ff1 fs0 fc0 sc1 ls0 ws0">第<span class="_ _4"> </span><span class="ff2">8<span class="_ _4"> </span><span class="ff3">到</span></span>第<span class="_ _3"> </span><span class="ff2">11<span class="_ _4"> </span></span>题基于这<span class="ff3">样</span>的三个<span class="ff3">表即</span>学生<span class="ff3">表<span class="_ _4"> </span><span class="ff2">S</span></span>、<span class="ff3">课</span>程<span class="ff3">表<span class="_ _3"> </span><span class="ff2">C<span class="_ _4"> </span></span></span>和学生选<span class="ff3">课表<span class="_ _4"> </span><span class="ff2">SC</span></span>，<span class="ff3">它们</span>的结构<span class="ff3">如</span>下：</div><div class="t m0 x2 h3 yaa ff2 fs0 fc0 sc1 ls0 ws0"> S(S#<span class="ff1">，</span>SN<span class="ff1">，</span>SEX<span class="ff1">，</span>AGE<span class="ff1">，</span>DEPT)</div><div class="t m0 x2 h3 yab ff2 fs0 fc0 sc1 ls0 ws0"> C(C#<span class="ff1">，</span>CN)</div><div class="t m0 x2 h3 yac ff2 fs0 fc0 sc1 ls0 ws0"> SC(S#<span class="ff1">，</span>C#<span class="ff1">，</span>GR<span class="_ _5"></span>ADE)</div><div class="t m0 x5 h3 yad ff1 fs0 fc0 sc1 ls0 ws0">其中：<span class="ff2">S#</span>为学<span class="ff3">号</span>，<span class="ff2">SN<span class="_ _4"> </span></span>为<span class="ff3">姓名</span>，<span class="ff2">SEX<span class="_ _4"> </span></span>为性<span class="ff3">别</span>，<span class="ff2">AGE<span class="_ _4"> </span></span>为<span class="ff3">年龄</span>，<span class="ff2">DEPT<span class="_ _3"> </span></span>为系<span class="ff3">别</span>，<span class="ff2">C#</span>为<span class="ff3">课</span>程<span class="ff3">号</span>，<span class="ff2">CN<span class="_ _4"> </span></span>为<span class="ff3">课</span>程<span class="ff3">名</span>，<span class="ff2">GR<span class="_ _5"></span>ADE<span class="_ _4"> </span><span class="ff1">为成<span class="ff3">绩</span>。</span></span></div><div class="t m0 x2 h3 yae ff2 fs0 fc0 sc1 ls0 ws0">8<span class="ff1">、<span class="ff3">检索所</span>有比<span class="ff3">“王华”年龄</span>大的学生<span class="ff3">姓名</span>、<span class="ff3">年龄</span>和性<span class="ff3">别</span>。正确的<span class="_ _4"> </span></span>SELECT<span class="_ _3"> </span><span class="ff1">语<span class="ff3">句</span>是 <span class="_ _22"></span> <span class="ff2">a <span class="_ _23"></span><span class="ff1"> <span class="_ _24"> </span> 。 </span></span></span></div><div class="t m0 x2 h3 yaf ff2 fs0 fc0 sc1 ls0 ws0"> A<span class="ff1 fc1">．<span class="ff2">SELECT SN</span>，<span class="ff2">AGE</span>，<span class="ff2">SEX FROM S</span></span></div><div class="t m0 x2 h8 yb0 ff2 fs0 fc1 sc1 ls0 ws0"> WHERE AGE<span class="ff3">＞</span>(SELECT A<span class="_ _5"></span>GE FROM S</div><div class="t m0 x2 h8 yb1 ff2 fs0 fc1 sc1 ls0 ws0"> WHERE SN=“<span class="ff3">王华”</span>)</div><div class="t m0 x2 h3 yb2 ff2 fs0 fc0 sc1 ls0 ws0"> B<span class="ff1">．</span>SELECT SN<span class="ff1">，</span>AGE<span class="ff1">，</span>SEX</div><div class="t m0 x2 h4 yb3 ff2 fs0 fc0 sc1 ls0 ws0"> FROM S</div><div class="t m0 x2 h8 yb4 ff2 fs0 fc0 sc1 ls0 ws0"> WHERE SN<span class="ff3">＝“王华”</span></div><div class="t m0 x26 h3 yaf ff2 fs0 fc0 sc1 ls0 ws0"> C<span class="ff1">．</span>SELECT SN<span class="ff1">，</span>AGE<span class="ff1">，</span>SEX FROM S</div><div class="t m0 x27 h8 yb0 ff2 fs0 fc0 sc1 ls0 ws0">WHERE AGE<span class="ff3">＞</span>(SELECT A<span class="_ _5"></span>GE</div><div class="t m0 x27 h8 yb1 ff2 fs0 fc0 sc1 ls0 ws0"> WHERE SN=“<span class="ff3">王华”</span>)</div><div class="t m0 x26 h3 yb2 ff2 fs0 fc0 sc1 ls0 ws0"> D<span class="ff1">．</span>SELECT SN<span class="ff1">，</span>AGE<span class="ff1">，</span>SEX FROM S</div><div class="t m0 x26 h3 yb5 ff2 fs0 fc0 sc1 ls0 ws0"> WHERE AGE<span class="ff3">＞王华<span class="ff1">．</span></span>AGE</div><div class="t m0 x2 h3 yb6 ff2 fs0 fc0 sc1 ls0 ws0">9<span class="ff1">、<span class="ff3">检索</span>选修<span class="ff3">课</span>程<span class="ff3">“</span></span>C2”<span class="ff1">的学生中成<span class="ff3">绩</span>最高的学生的学<span class="ff3">号</span>。正确的<span class="_ _4"> </span></span>SELECT<span class="_ _3"> </span><span class="ff1">语<span class="ff3">句</span>是 答案：</span>D</div></div><div class="t m0 x28 h4 yb7 ff2 fs0 fc0 sc1 ls0 ws0"> R</div><div class="t m0 x28 h4 yb8 ff2 fs0 fc0 sc1 ls0 ws0">A<span class="_ _25"> </span>B<span class="_ _25"> </span>C<span class="_ _25"> </span>D</div><div class="t m0 x28 h4 yb9 ff2 fs0 fc0 sc1 ls0 ws0">a<span class="_ _26"> </span>b<span class="_ _26"> </span>c<span class="_ _27"> </span>d</div><div class="t m0 x28 h4 yba ff2 fs0 fc0 sc1 ls0 ws0">a<span class="_ _26"> </span>b<span class="_ _26"> </span>e<span class="_ _26"> </span>f</div><div class="t m0 x28 h4 ybb ff2 fs0 fc0 sc1 ls0 ws0">a<span class="_ _26"> </span>b<span class="_ _26"> </span>h<span class="_ _28"> </span>k</div><div class="t m0 x28 h4 ybc ff2 fs0 fc0 sc1 ls0 ws0">b<span class="_ _28"> </span>d<span class="_ _26"> </span>e<span class="_ _26"> </span>f</div><div class="t m0 x28 h4 ybd ff2 fs0 fc0 sc1 ls0 ws0">b<span class="_ _28"> </span>d<span class="_ _26"> </span>d<span class="_ _28"> </span>l</div><div class="t m0 x28 h4 ybe ff2 fs0 fc0 sc1 ls0 ws0">c<span class="_ _27"> </span>k<span class="_ _27"> </span>c<span class="_ _29"> </span>d</div><div class="t m0 x28 h4 ybf ff2 fs0 fc0 sc1 ls0 ws0">c<span class="_ _27"> </span>k<span class="_ _27"> </span>e<span class="_ _26"> </span>f</div><div class="t m0 x29 h4 yc0 ff2 fs0 fc0 sc1 ls0 ws0"> S</div><div class="t m0 x29 h4 yc1 ff2 fs0 fc0 sc1 ls0 ws0">C<span class="_ _2a"> </span>D</div><div class="t m0 x29 h4 yc2 ff2 fs0 fc0 sc1 ls0 ws0">c<span class="_ _2b"> </span>d</div><div class="t m0 x29 h4 yc3 ff2 fs0 fc0 sc1 ls0 ws0">e<span class="_ _2c"> </span>f</div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
数据库习题+试卷
