数据库初试笔试题
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
5)in a select statement that includes a where clause,where is the order by clause placed in the select statement?______.
diately after the select clause
re the where clause
r all clause
r the where clause
re the from clause
-
2017年考研的必备干货
2016年的考研即将进入复试阶段,2017年的考研准备工作也已经拉开帷幕,下面是小编为你们准备的2017年考研的必备干货,一起来看看吧。1.考研高校选择A.三本(本地区、本学校、本专业)最容易成功;B.三跨(跨地区、跨学校、跨专业)最难成功;C.一本二跨(本专业、跨地区、...
-
考研现场确认的四大细节
下面是小编为大家整理的考研现场确认的四大细节,欢迎大家的阅读。一、带齐证件和材料:在11月10日之前,做好一切准备工作。一定记住,学校老师办公和现场确认都只有五天时间。现在有问题,还来得及处理,不要等到最后一天才发现有问题。现场确认就是为了核对考生信息,以防...
-
2016考研英语一小作文预测范文
应用文考察类型:书信、通知书信作文预测:通知、投诉信、建议信、咨询信、求学(职)、请求信、感谢信、备忘录预测作文范文通知Directions:Supposeyouruniversityisgoingtohostasummercampforhighschoolstudents.Writeanoticeto1)brieflyintroducethecampactivitie...
-
2017年重庆医科大学医用数学考研大纲
随着2017考研的到来,各院校的考研大纲也开始出台了。下面是小编为大家整理收集的关于2017年重庆医科大学医用数学考研大纲的相关内容,欢迎大家的阅读。Ⅰ.考试性质医用数学考试是为招收生物医学工程及相关专业的硕士研究生而设置具有选拔性质的考试科目,其目的是...