资源描述：
《神州数码11道面试题.docx》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、神州数码11道面试题1)Whichstatementshowsthemaximumsalarypaidineachjobcategoryofeachdepartment?_____B__A.selectdept_id,job_cat,max(salary)fromemployeeswheresalary>max(salary);B.selectdept_id,job_cat,max(salary)fromemployeesgroupbydept_id,job_cat;C.selectdept_id,job_cat,max(salary)fromemployee
2、s;D.selectdept_id,job_cat,max(salary)fromemployeesgroupbydept_id;E.selectdept_id,job_cat,max(salary)fromemployeesgroupbydept_id,job_cat,salary;2)descriptionofthestudentstable:sid_idnumberstart_datedateend_datedatewhichtwofunctionarevalidonthestart_datecolumn?_____CE____。A.sum(start_
3、date)B.avg(start_date)C.count(start_date)D.avg(start_date,end_date)E.min(start_date)F.maximum(start_date)3)forwhichtwoconstraintsdoestheoracleserverimplicitlycreateauniqueindex?___BE___。A.notnullB.primaryC.foreignkeyD.checkE.unique4)inaselectstatementthatincludesawhereclause,whereis
4、thegroupbyclauseplacedintheselectstatement?___E___。A.immediatelyaftertheselectclauseB.beforethewhereclauseC.beforethefromclauseD.aftertheorderbyclauseE.afterthewhereclause5)inaselectstatementthatincludesawhereclause,whereistheorderbyclauseplacedintheselectstatement?___C___.A.immedia
5、telyaftertheselectclauseB.beforethewhereclauseC.afterallclauseD.afterthewhereclauseE.beforethefromclause6)evaluatetheretwosqlstatements___A___.Selectlast_name,salaryfromemployeesorderbysalary;Selectlast_name,salaryfromemployeesorderby2asc;A.thesameresultB.differentresultC.theseconds
6、tatementreturnsasyntaxerror7)youwouldliketodisplaythesystemdateintheformat“2005111014：44：17”。Whichselectstatementshouldyouuse?___D___。A.selectto_date(sydate,’yearmmddhh:mm:ss’)fromdual;B.selectto_char(sydate,’yearmonthdayhh:mi:ss’)fromdual;C.selectto_date(sydate,’yyyymmddhh24:mi:ss’
7、)fromdual;D.selectto_char(sydate,’yyyymmddhh24:mi:ss’)fromdual;E.selectto_char(sydate,’yy-mm-ddhh24:mi:ss’)fromdual;8)whichselectstatementwilltheresult‘elloworld’fromthestring‘Helloworld’?__D____.A.selectsubstr(‘HelloWorld’,1)fromdual;B.selectsubstr(trim(‘HelloWorld’,1,1))fromdual;C
8、.selectlower(substr
