对于学生信息表S(SNUMBER,SNAME,SEX,AGE,DEPT)(STUDENT 由学号 SNO,姓名SNAME,性别SEX,年龄AGE,所在系DEPT5个属性组成,其中SNUMBER为主码),求年龄20~23岁之间的学生姓名和年龄,正确的语句是()。
A. SELECT SNAME,AGE FROM S WHERE AGE>20 AND AGE<23
B. SELECT SNAME,AGE FROM S WHERE AGE BETWEEN 20 AND 23
C. SELECT *FROM S WHERE. AGE BETWEEN 20 AND 23
D. 以上均不正确
假定在工程文件中有一个标准模块,其中定义了如下记录类型: Type Books Name As String*10 TelNum As String*20 End Type 要求当执行事件过程Command1_Click时,在顺序文件Person. txt中写入一条记录。下列能够完成该操作的事件过程是______。
A. Private Sub Command1_Click() Dim B As Books Open"c:\Person. txt" For Output As #1 B. Name=InputBox("输入姓名") B. TelNum=InputBox("输入电话号码") Write #1, B. Name, B. TelNum Close #1 End Sub
B. Private Sub Command1_Click() Dim B As Books Open"c:\Person txt" For Output As #1 B. Name=InputBox("输入姓名") B. TelNum=InputBox("输入电话导码") Print #1, B. Name, B. TelNum Close #1 End Sub
C. Private Sub Command1_Click() Dim B As Books Open"c:\Person. txt" For Output As #1 Name=InputBox("输入姓名") TelNum=InputBox("输入电话号码") Print #1, B Close #1 End Sub
D. Private Sub Command1_Click() Dim B As Books Open "c:\Person txt" For Output As #1 Name=InputBox("输入姓名") TelNum=InputBox("输入电话号码") Print #1, B Name, B. TelNum Close #1 End Sub
听力原文:M: Maths Department, Doctor Winston speaking.
W: Hello, Prof. Winston. This is Eliza Smith calling, I'm living two doors down from your teaching assistant, David Williams. David asked mc to call you because he lost his voice and can't talk to you himself.
M: Lost his voice? Oh, what a shame! Is there anything I can do for him?
W: Well, he has a class this afternoon from 2:30 to 4:00 and he won't be able to teach it, but he doesn't want to cancel it either.
M: Want me to try to find somebody else to teach the class?
W: No, not exactly. What he wants to do is to get someone to go in for him, just to pass back the mid-term exams. He's already marked them and they are on the desk in his office. The whole thing wouldn't take more than ten minutes.
M: His class is at 2:30, eh? Well at that time I am going to he on campus anyway; so I can do it for him. What room is his class in?
W: Building 4, room two-fourteen. Will you need his office key to get the exams? He's given it to me and I could bring it to yon.
M: Actually, that won't be necessary. We have a master key in the maths department. So I can get into his office if necessary.
W: Thanks very much, Prof. Winston. David doesn't have an other dross to teach until Tuesday, and hopefully, he will be able to talk by then. He'll tall you as soon as be can. Oh, yes, I almost forgot, Could you put the next assignment on the board, too? It’s all the problems on Page 45, and they are due at the next class.
M: No trouble at all, Thanks for passing all the news about David, and please tell him not to worry about anything.
(23)
A. He can't find his office key.
B. He has misplaced some exams.
C. He is unable to speak.
D. He doesn't like his classroom.