神州數(shù)碼筆試題目選擇部分分享

1、神州數(shù)碼筆試題目選擇部分分享選擇題：1) Which statementshows the maximum salary paid ineach 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 , m

2、ax(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) descripti on of the stude nts table:sid_id nu mberstart_date dateen d_date datewhich two fun cti on are v

3、alid on the start_date column?。A。sum(start_date)B。avg(start_date)C。cou nt(start_date)D。avg(start_date , end_date)E。 mi n(start_date)F。maximum(start_date)3) for which two con strai ntsdoes the oracleimplicitly create a unique in dex?。A。not nullB。primaryC。foreig n keyD。checkE。unique4) i n a select sta

4、teme nt that in cludes a where clauseis 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) i n a select stateme nt that in cludes a where clauseis the order by

5、clause placed in the select statement?server,where,whereA。immediately after the select clauseB。before the where clauseC。after all clauseD。after the where clauseE。before the from clause6) evaluate there two sql statements。Select last_name , salary from employees order by salary;Select last_name , sal

6、ary from employees order by 2 asc;A。the same result B。 different result C。 the second stateme nt returns a syn tax error7) you would like to display the system date in the format2005111014: 44： 17。Which select statement should youuse?。A。select to_date(sydate , yearmmdd hh:mm:ss )from dual;B。select t

7、o_char(sydate , yearm on thday hh:mi:ss )from dual;c。selectto_date(sydate ,yyyymmddhh24:mi:ss)fromdual;D。selectto_char(sydate ,yyyymmddhh24:mi:ss)fromdual;E。selectto_char(sydate ,yy-mm-ddhh24:mi:ss)fromdual;8) which select stateme nt will the result ello world from thestri ng Hello world ? 。A。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 st