新开发的数据库管理系统中,数据库管理员张工发现被用户频繁运行的某个查询处理程序使用了多个表的连接,产生这一问题的原因在于 (1) 。在保证该处理程序功能的前提下提高其执行效率,他应该 (2) 。 2()
A. 建立该查询处理程序所用到表的视图,并对程序做相应的修改
B. 建立查询处理程序所用到表进行必要的合并,并对程序做相应的修改
C. 修改该程序以减少所使用的表
D. 尽可能采用嵌套查询实现该程序的功能
查看答案
实体-联系模型(简称E-R模型)中的基本语义单位是实体和联系。E-R模型的图形表示称为E-R图。联系可以同 (1) 实体有关。实体与实体之间的联系可以是 (2) 。利用E-R模型进行数据库的概念设计,可以分成三步:首先设计局部ER,然后把各个局部E-R模型综合成—个全局的模型,最后对全局E-R模型进行 (3) ,得到最终的E-R模型,E-R模型向关系模式的转换规则是把一个实体类型转换成一个关系模式,实体的属性是关系的属性,实体的键是关系的键。把一个联系类型转换成一个 (4) ,参与该联系类型的各实体的键及联系的属性转换成 (5) ,其中的键由实体与实体之间的联系决定。 1()
A. 0个
B. 1个或多个
C. 1个
D. 多个
实体-联系模型(简称E-R模型)中的基本语义单位是实体和联系。E-R模型的图形表示称为E-R图。联系可以同 (1) 实体有关。实体与实体之间的联系可以是 (2) 。利用E-R模型进行数据库的概念设计,可以分成三步:首先设计局部ER,然后把各个局部E-R模型综合成—个全局的模型,最后对全局E-R模型进行 (3) ,得到最终的E-R模型,E-R模型向关系模式的转换规则是把一个实体类型转换成一个关系模式,实体的属性是关系的属性,实体的键是关系的键。把一个联系类型转换成一个 (4) ,参与该联系类型的各实体的键及联系的属性转换成 (5) ,其中的键由实体与实体之间的联系决定。 2()
A. 一对一和一对多
B. 一对一和多对多
C. 一对多和多对多
D. 一对一、一对多和多对多
Directions:This part is to test your reading ability.There are five tasks for you to fulfill.Youshould read the reading materials carefully and do the tasks as you are instructed.TASK 1Directions:After reading the following passage,you will find five questions or unfinshedstatements numbered from 36 to 40.For each question or statement there are four choicesmarkted A,B,C and D.You should make the correct choice and mark the corresponding letter onthe Answer Sheet with a single line through the center. Do you remember a time when people were a little nicer and gentler with each other I certainly do and I feel that much of the world has somehow gotten away from that.Too often Isee people rushing into elevators without giving those inside a chance to get off first,or never saying"thank you",when others hold the door open for hem.We get lazy,and in outr laziness we think that something like simple"thank you"does not really matter.But it can matter very much.The fact is that no matter how nicely we dress or how beautifully we decorate our homes,we cannot be truly elegant unless we have good manners,because elegance and good manners alwaysgo hand in hand.If fact,I think of good manners as a sort of hidden beauty secret.Haven’t you noticed that happens,but it does.Take the long-lost art saying"thank you",like wearing a little make-up or making sure you hair is neat.Getting into the habit of saying"thank you"can makeyou feel better about yourself.Good manners add to your image while an angry face makes the best-dressed person look ugly. What does the writer say about the people ofthe past
A. They were nicer and gentler.
B. They paid more attention to their appearance.
C. They were willing to spend more money on clothes.
D. They were more aware of changes in fashion.
某高校学生管理系统的新生数据取自各省招生办公室的考生信息,筛选出录取本校的考生信息直接导入,再根据录取专业划分班级并生成学号(学号的前四位与所在班级编号相同)。学校的学生管理业务多以班级和学生为单位处理,应对学生信息表 (1) ,以减少I/O访问次数,提高系统性能。设该系统的学生关系模式为:学生(学号,姓名,性别,出生日期,身份证号,籍贯,家庭所在地),在该系统运行过程中,DBA发现频繁访问学生关系的查询程序只涉及学号、姓名、性别和出生日期属性,为提高该查询程序的性能,应 (2) 。 1()
A. 建立学号的普通索引
B. 建立学号的UNIQUE索引
C. 建立学号的CLUSTER索引
D. 按学号进行HASH分布