神州数码试题

设计一个Windows下的C语言的，基于TCP的多线程服务器和客户端发送程序。
1，对服务器程序，服务器收到客户端发出的字符串后用printf()语句显示出来，要求对客户端报文的处理采用多线程并发处理方式；
2，对于客户端程序，客户端收到来自键盘输入的字符，然后发给指定IP的服务器上。

[我去笔试的时候就碰到这个问题了,自己对这方面不熟悉,所以就没做,把时间放到其他几个编程题了.]



1)Which statement shows the maximum salary paid in each job category of each department?_______
A. select dept_id, job_cat,max(salary) from employees where salary > max(salary);
B. select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat;
C. select dept_id, job_cat,max(salary) from employees;
D. select dept_id, job_cat,max(salary) from employees group by dept_id;
E. select dept_id, job_cat,max(salary) from employees group by dept_id,job_cat,salary;

2)description of the students table:
sid_id number
start_date date
end_date date
which two function are valid on the start_date column?_________。
A.sum(start_date)
B.avg(start_date)
C.count(start_date)
D.avg(start_date,end_date)
E.min(start_date)
F.maximum(start_date)

3)for which two constraints does the oracle server implicitly create a unique index?______。
A. not null
B. primary
C. foreign key
D. check
E. unique

4)in a select statement that includes a where clause,where is the group by clause placed in the select statement?______。
A. immediately after the select clause
B. before the where clause
C. before the from clause
D. after the order by clause
E. after the where clause


问了一下，答案好像是这样：
1.b
2.ce
3.be
4.e