当前位置:IT认证>计算机二级

问题:

[单选] SQL语句的WHERE子句可以限制表中的记录,完成同样功能的宏命令是

A . Requery
B . FindRecord
C . ApplyFilter
D . FindNextRecord

下列If语句的功能是统计性别为男、职称为副教授以上且年龄小于40岁的人数,错误的语句是 If sex="男" And age<40 lnStr(duty,"教授")>0 Then n=n+1。 If sex="男" And age<40 InStr(duty="教授" 0rduty="副教授")>0 Thenn=n+1。 If sex="男" And age<40 Right(duty,2)= "教授" Then n=n+1。 If sex="男" And age<40 And(duty;"教授" Or duty="副教授") Then n=n+l。 下列表达式中,与DateDiff(”m”,#2013-11-25#,Date())等价的表达式是 (Month(date())-Month(#2013-11-25#))。 (MonthName(date())-MonthName(#2013-11-25#))。 (year(date())-year(#2013-11-25#))*12-(month(date())-month(#2013-11-25#)。 (year(date())-year(#2013-11-25#))*12+(month(date())-month(#2013-11-25#)。 下列VBA变量名中,正确的是 IF。 7AB。 AB;7。 AB7。 The Klondike was the scene of one of the biggest gold rushes the world has ever known. location。 view。 even。 landscape。 Promising Results from Cancer Study    A new experimental vaccine(疫苗)has shown promising results in the fight against lung cancer.In a small Texas-based study,a vaccine developed by scientists at Baylor University Medical Centre in Dallas,USA,cured lung cancer in some patients and slowed the progress of the disease in others.     Researchers have reported encouraging findings from this small study.Forty-three patients suffering from lung cancer were involved in these trials.Ten of these patients were in the early stages and thirty—three in the advanced stages of the disease.They were injected with me Vaccine every two weeks for three months,and were carefully monitored for three years.In three of the patients in me advanced stages of cancer,the disease disappeared and in the others,it did not spread for five to twenty—four months.However,no great difference was seen in the patients in the early stages of the illness.    This new vaccine uses the patients’own immune、system.It is made specifically for each patient and is injected into the arm or leg.It stimulates the body’s immune system,which then recognizes that the cancer cells are harmful,and attacks and destroys them.    The vaccine could be effective against other forms of cancer.It offers great hope for the treatment of cancer in general,although further studies are needed before such treatment can be widely used.根据以上内容,回答{TSE}题。{TS}The vaccine cured all the participants in the trial. Right。 Wrong。 Not mentioned。 SQL语句的WHERE子句可以限制表中的记录,完成同样功能的宏命令是
参考答案:

  参考解析

【答案】C
【解析】Requery操作可以通过重新查询控件的数据源来更新活动对象指定控件中的数据;FindRecord操作可以查找符合参数指定条件的数据的第一个实例;ApplyFilter操作可以对表、窗体或报表应用筛选、查询或SQL中Where子句。因此本题应选择C选项。

相关题目:

在线 客服