SELECT erdepa,avg（ersalary) FROM examiner GROUP BY erdepa HAVING erdepa IN （select erdepa from examiner where ername='关晓彤')； 该语句的功能是查询（）。

A、各个学院考官的平均年龄，按平均年龄升序排列

B、各个学院考官的平均年龄，按平均年龄降序排列

C、所有考官的平均年龄，按平均年龄降序排列

D、所有考官的平均年龄，按平均年龄升序排列

A、SELECT eid,ename FROM exampaper WHERE eid in (SELECT eid FROM eeexam GROUP BY eid HAVING COUNT(eeid)=(SELECT COUNT(eeid) FROM examinee) );

B、SELECT eid,ename FROM exampaper WHERE NOT EXIST (SELECT * FROM examinee WHERE NOT EXIST (SELECT * FROM eeexam WHERE examinee.eeid=eeid and exampaper.eid=eid) );

C、SELECT eid，ename FROM exampaper WHERE NOT EXISTS （（SELECT eeid FROM examinee） EXCEPT （SELECT eeid FROM eeexam WHERE exampaper.eid=eid））;

D、SELECT * FROM examinee ORDER BY eeid limit 2 offset ((SELECT count(*) FROM examinee)-2);

E、SELECT * FROM examinee ORDER BY eeid LIMIT (SELECT COUNT(*) FROM eeexam);

F、SELECT * FROM department WHERE EXISTS (SELECT * FROM examiner WHERE erdepa=department. dname AND eid= ername= '范冰冰');

G、SELECT eedepa, AVG(eeage) FROM examinee GROUP BY eedepa HAVING eedepa IN (SELECT eedepa FROM examinee WHERE eename='刘诗诗');

H、SELECT dname, (SELECT COUNT(*) FROM examiner WHERE department.dname = examiner.erdepa) FROM department;

I、SELECT (SELECT eedepa FROM examinee WHERE eeexam.eeid=examinee.eeid), AVG(achieve) FROM eeexam GROUP BY (SELECT eedepa FROM examinee WHERE eeexam.eeid=examinee.eeid);

A、WITH avgach (eeid,avgachieve) AS ( SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;

B、WITH avgach (eeid,avgachieve) ( SELECT eeid,AVG(achieve) FROM eeexam GROUP BY eeid ) SELECT COUNT(*) FROM avgach WHERE avgachieve>=80;

C、SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid )AS avgach (eeid,avgachieve) WHERE avgachieve>=80;

D、SELECT COUNT(*) FROM (SELECT eeid,avg(achieve) FROM eeexam GROUP BY eeid ) avgach (eeid,avgachieve) WHERE avgachieve>=80;

E、SELECT dname, (SELECT COUNT(*) FROM examiner WHERE department.dname = examiner.erdepa) FROM department WHERE avgachieve>=80;

F、SELECT * FROM erexam NATURAL LEFT OUTER JOIN exampaper;

Select emp_id，emp_name，sex，title，wage from employee order by emp_name句子得到的结果集是按()排序。

A.emp_id

B.emp_name

C.sex

D.wage

一个完整的SELECT语句包括()子句。

A、FROM

B、WHERE

C、SELECT

D、GROUPBY

E、ORDERBY

A、报考了3门以上试卷的报考号和报考门数，按报考门数降序排列。

B、报考了3门以上试卷的报考号，按报考门数升序排列。

C、报考了3门以下试卷的报考号，按报考门数降序排列。

D、这个语句不合法

Your network contains a DNS server named DNS1 that runs Windows Server 2008 R2.You need to be notified by e-mail if the DNS service logs errors or warnings. The solution must minimize the number of e-mail notifications you receive.What should you do？（）

A. Create an alert in Performance Monitor.

B. Run the Configure a DNS Server Wizard.

C. Select the DNS Server log from Event Viewer and attach a task to the log.

D. Create a custom view from Event Viewer and attach a task to the custom view.

The Citizen Herald SUBSCRIPTION OFFER Covering every topic, and all the latest news, it is no doubt that The Citizen Herald is our number 1 pick. The Citizen Herald covers everything, from sports to money, travel to local events, The Citizen Herald has it all. For the most part, you can get The Citizen Herald delivered straight to your door. Every month, this award-winning publication includes insightful articles, editorial pieces, and columns by experts in finance and economics. There honestly isnt that much we can say about The Citizen Herald, because The Citizen Herald covers almost every subject that you need to know about on a monthly basis. If you want to subscribe to The Citizen Herald, then complete the form. below. Name: Joseph Collins Company: Collins Consulting Company Address: 34 Blackbill Ave, West Town 35693 E-mail: jcollins@collinsconsulting. com Indicate one of the following: × YES! Please send me The Citizen Herald for 2 years(24 issues)for just $90.00→a savings of almost 48% off the regular newsstand price. _____ Please send me The Citizen Herald for 1 year(12 issues)for just $48.00→a savings of almost 37% off the regular newsstand price. _____ Please send me The Citizen Herald for 6 months(6 issues)for just $25.00→a savings of almost 35% off the regular newsstand price. Payment Bill me(×)Money order( )Credit card( )Other( ) Please allow two to three weeks for your first issue to arrive.

How often is The Citizen Herald published?

A．Daily.

B．Weekly.

C．Monthly.

D．Yearly.

A computer is a machine designed to perform. work mathematically and to store and select information that has been fed into it. It is nm by either mechanical or electronic means. These machines can do a great deal of complicated work in a very short time. A large computer, for example, can add or subtract nine thousand times a second, multiply a thousand times a second, or divide five hundred times a second. Its percentage of error is about one in a billion digits. It has been estimated that human beings making calculations average about one mistake per two hundred digits.

The heart of an electronic computer lies in its vacuum tubes, or transistors. Its electronic circuits work a thousand times faster than the nerve cells in the human brain. A problem that might take a human being two years to solve can be solved by a computer in one minute, but in order to work properly, a computer must be given instructions--it must be programmed. Computers can be designed for many specialized purposes--they can be used to prepare payrolls, guide airplane flights, direct traffic, even to play chess. Computers play an essential role in modern automation in many plants and factories throughout the world.

A computer is a machine designed to ______.

A．perform. work mathematically

B．perform. complicated calculations

C．store and select information

D．all of the above