问题 单项选择题

在Access中已建立了“学生”表,表中有“学号”“姓名”“性别”和“入学成绩”等字段。执行如下SQL命令:SELECT性别,AVG(入学成绩)FROM学生GROUP BY性别其结果是( )。

A) 计算并显示所有学生的性别和入学成绩的平均值
B) 按性别分组计算并显示性别和入学成绩的平均值
C) 计算并显示所有学生的入学成绩的平均值
D) 按性别分组计算并显示所有学生的入学成绩的平均值

答案

参考答案:B

解析: 此SQL命令中,CROUP BY短语后面跟“性别”字段,表示查询结果按照“性别”分组,而在SELECT列表中列出“性别”和AVC(入学成绩),表示列出性别和入学成绩的平均值。所以此SQL命令的结果就应当为:按性别分组计算并显示性别和入学成绩的平均值,所以选项B)正确。

单项选择题
完形填空

根据短文内容,从短文后的选项中选出能填入空白处的最佳选项。选项中有两项为多余选项。(答案涂在答题卡上E="AB" F="AC" G=AD)

No.1 Will the economic climate improve this year?

I don't think we will see too much improvement this year, but of course I hope so.

No.2 How important is an MBA compared to experience?

I won't say a degree isn't important.一____1 ____.When I look at potential employees, I look atwhat they have done in the past that I can use to help me tomorrow.

No.3 How can you ensure your job is safe with the economy so shaky?

No job is safe.Never will it be.The half-life of any particular skill set is, at most, fiveyears.And that's on the long side.  2__Be curious, be willing to learn, have a moralcompass and know what gives your life meaning.

No.4 When the job market is this bad, how can you distinguish yourself as a andidate?

Know the company, its competitive position, recent announcements, stock-price history.Do a Google or Yahoo search on the person you'll be meeting with and you should be able tofind something about him or her.Then develop an "outsider's view" of their key needs andopportunities.  3___

No.5 I'm graduating from business school this spring.  4___

If you haven't already secured an internship(职业院校证)within your chosen field, do sonow.Take any internship; forget about being paid.  5___ the experience in your field andthe opportunity to check out onto a possible employee.Your connections, and yourconnectionsconnections, will be the hot ticket to get you in the door for job interviews.

A.You are after two things.

B.Do all you can to be the solution to someone else's problem.

C.Will technology create more jobs?

D.Any job advice?

E.But nothing beats experience.

F.What will keep you alive?

G.Differentjobs needs different skills.