數(shù)據(jù)庫(kù)初試筆試題

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?_________，

數(shù)據(jù)庫(kù)初試筆試題

。
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?______，

資料共享平臺(tái)

《數(shù)據(jù)庫(kù)初試筆試題》(http://www.szmdbiao.com)。
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?______.
a.immediately after the select clause
b.before the where clause
c.after all clause
d.after the where clause
e.before the from clause
 

【數(shù)據(jù)庫(kù)初試筆試題】相關(guān)文章：

精選數(shù)據(jù)庫(kù)筆試題目11-01

360筆試題目06-27

筆美國(guó)國(guó)家儀器試題目09-23

數(shù)據(jù)庫(kù)基本概念筆試題08-25

搜狐產(chǎn)品筆歸分享筆試題目07-05

公司面試初試評(píng)估表10-21

考研初試時(shí)間與報(bào)考流程08-27

ASP.NET和數(shù)據(jù)庫(kù)方面的一套筆試題06-12

建行的初試復(fù)試經(jīng)驗(yàn)之談09-29

考研初試重要注意事項(xiàng)08-30