更新时间:2018-11-22 15:24作者:李天扬老师
神州程序类笔试题分享:
神州数码笔试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;