文档介绍：神州数码程序类笔试题分享
神州程序类笔试题分享:
神州数码笔试1)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)
神州数码笔试2)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
神州数码笔试3)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;
神州数码笔试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
神州数码笔试5)in a select statement that includes a where clause,where is the order by clause placed in the select statement?_____