题目内容

20～27题使用的数据如表1和表2所示。表1 教师表(TEACHER.DBF) 教师号姓名性别籍贯职称年龄工资／元 0001 王吉兵男江苏讲师 27 2003.50 0002 张晓春女安徽副教授 28 2800.50 0003 左燕女江苏讲师 25 2040.00 0004 赵华男安徽副教授 35 2800.00 0005 李宁男山东讲师 24 2500.00 表2 讲课表(JK.DBF) 教师号课号学时 0001 0001 98 0002 0002 76 0001 0002 80 0002 0003 69 0003 0001 75 0003 0003 68 0004 0001 89 0005 0001 76 0004 0002 65 0003 0002 90 创建一个名为RS的视图，用来显示所有教师的教师号、姓名和总课时，下面正确的语句是______。

A. SELECT TEACHER.教师号，TEACHER.姓名，JK.总学时；
B. WHERE TEACHER.教师号=JK.教师号；
C. GROUP BY TEACHER.教师号INTO CURSOR RS
D. CREATE VIEW RS AS：
E. SELECT TEACHER.教师号，TEACHER.姓名，JK.总学时；
F. WHERE TEACHER.教师号=JK.教师号GROUP BY TEACHER.教师号
G. SELECT TEACHER.教师号，TEACHER.姓名，JK.总学时；
H. WHERE TEACHER.教师号=JK.教师号；
I. GROUP BY TEACHER.教师号INTO CURSOR RS
J. CREATE VIEW RS AS；
K. SELECT TEACHER.教师号，TEACHER.姓名，SUM(JK.学时)AS总学时；
L. WHERE TEACHER.教师号=JK.教师号GROUP BY TEACHER.教师号

查看答案

搜索结果不匹配？点我反馈

更多问题

[听力原稿]M：Are you going to apologize for breaking that windowW：Why should II didn’t throw the ball. How does the man feel about the situation（）

Angry.
B. Disappointed.
C. Happy.
D. Worried.

在窗体上画一个命令按钮，然后编写如下程序：Function fun(ByVal num As Long)As Long Dim k As Long k=1 num=Abs(num) Do While num k=k*(num Mod 10) num=num\10 Loop fun=kEnd FunctionPrivate Sub Command1_ Click() Dim n As Long Dim r As Long n=InputBox(“请输入一个数”) n=CLng(n) r=fun(n) Print rEnd Sub 程序运行后，单击命令按钮，在输入对话框中输入“345”，输出结果为______。

What are the two kinds of sleep we experience every night Every night we have two kinds of sleep: active sleep and

Conversation 2Questions 8 to 10 are based on the conversation you’ve just heard.[听力原文] 8-10M：Hi I have some good news for you.W：What is itM：The teacher suggested that we go on a trip this Saturday.W：Oh，wonderful. Where shall we goM：How about going to the parkW：I don’t think it’s a good place to go to. We can go there another time. We should so farther away this time.M：Where do you think we should go thenW：How about the river in the suburbsM：I don’t think it’s a good idea. It’s not safe. Why not go to the mountains insteadW：That sounds good. Let’s go to the mountains to the south of the city. Where do they decide to go last（）

A. The park.
B. The river.
C. The suburbs.
D. The mountains.