工程师的英文考试试题

全英文，因为是国外认证。

这是去年的题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 numberstart_date dateend_date datewhich two function are valid on the start_date column?_________。(start_date)(start_date)(start_date)(start_date,end_date)(start_date)(start_date)3)for which two constraints does the oracle server implicitly create a unique index?______。A. not nullB. primaryC. foreign keyD. checkE. unique4)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 clauseB. before the where clauseC. before the from clauseD. after the order by clauseE. after the where clause5)in a select statement that includes a where clause,where is the order by clause placed in the select statement? after the selectthe whereallthe wherethe from clause6)evaluate there two sqllast_name,salary from employees order by salary;Select last_name,salary from employees order by 2 asc; same resultresultsecond statement returns a syntax error7) you would like to display the system date in the format“20051110 14：44：17”。Which select statement should you use?______。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;8)which select statement will the result ‘ello world’from the string‘Hello world’?. select substr(‘Hello World’,1)from dual;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;9)which are DML statements(choose all that apply) )Select 语句中用来连接字符串的符号是. “+” B. “&” C.“||” D.“|”问答题： 什么是聚集索引，什么是非聚集索引，什么又是主键？

网络工程师属于软考中级资格考试，网络工程师考试没有英语科目，但是上午科目会涉及到英语试题，因此考生需要掌握相关的英语词汇，以便能准确的答题。软考中级网络工程师包含两个考试科目：基础知识和应用技术。基础知识在上午考试，应用技术在下午考试。虽然网络工程师并没有单独的英语考试科目，但是上午基础知识科目通常会包含10道英语选择题。考试大纲中会说明需要掌握的相关英语知识，考生可以根据考试大纲进行复习。由于软考本身属于计算机类别的考试，因此考试内容可能会考察所考专业的一些常用词汇，也就是说考试内容多多少少会涉及到英语，所以大家在复习的时候要多了解一些计算机专业的英语名词。温馨提示：因考试政策、内容不断变化与调整，猎考网提供的以上信息仅供参考，如有异议，请考生以权威部门公布的内容为准！ 下方免费复习资料内容介绍：2018上半年信息系统项目管理师论文真题 格式：PDF大小： 网络规划设计师历年真题汇总 格式：ZIP大小：资格考试有疑问、不知道如何总结考点内容、不清楚报考考试当地政策，点击底部咨询猎考网，免费领取复习资料