神州数码笔试面试题（全有答案）
神舟面试题 笔试题 要去神舟数码软件公司面试的可以看看
神州数码
1)Which statement shows the maximum salary paid in each job category of each department?____B___
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?____C, E_____。
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?___BE___。
settingsunA. not null
B. primary
spring的发音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?___E___。
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?___C___.
A.immediately after the select clause
B.before the where clause
C.after all clause
D.after the where clausejava常见笔试题
E.before the from clause
6)evaluate there two sql statements____A__.
Select last_name,salary from employees order by salary;
Select last_name,salary from employees order by 2 asc;
A.the same result B.different result C.the second statement returns a syntax error
7) you would like to display the system date in the format“20051110 14：44：17”。Which select statement should you use?___D___。
A. select to_date(sydate,’yearmmdd hh:mm:ss’)from dual;
B. select to_char(sydate,’yearmonthday hh:mi:ss’)from dual;
C. select to_date(sydate,’yyyymmdd hh24:mi:ss’)from dual;
D. select to_char(sydate,’yyyymmdd hh24:mi:ss’)from dual;
E. select to_char(sydate,’yy-mm-dd hh24:mi:ss’)from dual;
淘宝主页面html代码
8)which select statement will the result ‘ello world’from the string‘Hello world’?__D____.
A. select substr(‘Hello World’,1
)from dual;windows2008r2离线激活
B. select substr(trim(‘Hello World’,1,1))from dual;
C. select lower(substr(‘Hello World’,1))from dual;
D. select lower(trim(‘H’from‘Hello World’))from dual;
spring的执行原理9)which are DML statements(choose all that apply)___B___.
www.doczj/doc/3d1584036.html, C.update D.at F.drop
10)Select 语句中用来连接字符串的符号是___C___.
A. “+” B. “&” C.“||” D.“|”
1.简述逻辑操作(&,|,^)与条件操作(&&,||)的区别。(15分)

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。