第4题: [简答题]当今世界,既非丝绸之路时代,亦非马可·波罗时代。昔日遥远的距离,被现代科学技术一下缩短到令人难以置信的程度。这是人类文明进步的共同成果。不论是中国的还是外国的历史经验一再证明,文化需要交流。只有交流,才能相互学习,相互了解;只有交流,才能共同去促进人类智慧向前发展,并共同享用其成果。 参考答案:
The world today is neither the times of the Silk Road nor that of Marco Polo. With the development of science and technology, great distances in the old days have been incredibly shortened, which is the common achievement of the progress of human civilization. The historical experiences of both China and other countries have proved repeatedly that culture calls for exchanges. Only through exchanges can we learn from each other and come to know each other better; only through exchanges can we give full play to human wisdom and enjoy the common fruits of civilization.
第31题: [单项选择]设有关系模式:教师表(教师号,教师名,所在系,工资),现需建立一个统计每个系全体教师工资总额的视图,正确的语句是______。 A. CREATE VIEW SalaryView(系名,工资总额)AS B. CREATE VIEW SalaryView(系名,工资总额)AS C. CREATE VIEW SalaryView AS D. CREATE VIEW SalaryView AS 参考答案:B 答案解析:[解析] 本题中待创建视图需要增加一列来表示每个系全体教师工资总额,因此需要使用用于求和的聚合函数SUM()。定义视图时如果某个目标列通过函数或者表达式产生时需要明确指定列名,则需要在视图名后说明列名