《神州数码笔试题目选择题部分.docx》由会员分享，可在线阅读，更多相关《神州数码笔试题目选择题部分.docx（5页珍藏版）》请在三一文库上搜索。
1、神州数码笔试题目选择部分分享神州数码笔试题目分享:选择题:1)Which statement shows the maximum salary paid in each job category of each department?Ao select dept_id, job_cat, max(salary) from employees where salary max(salary);Bo select dept_id, job_cat, max(salary) from employees group by dept_id, job_cat;Co select dept_id,job_
2、cat, max(salary) from employees;Do select dept_id,job_cat, max(salary) from employees group by dept_id;Eo select dept_id, job_cat, salary;job_cat, max(salary) from employees group by dept_id.2)description of thestudents table：sid_id numberstart_date dateend date datewhich two function are valid on t
3、he start date column?Aosum(start_date)Boavg (start_date)Cocount (start date)DoEomin(start_date)Fomaxi mum (star t _da te)avg(start_date, end_date)3)for which two constraints does the oracle server implicitly create a unique index?。Ao not nullBo primaryCo foreign keyDo checkEo unique by clause placed
4、 in the select statement?4)in a selectstatement that includes a whereclause, where is the groupAo immediately after the select clauseBo before the where clauseCo before the from clauseDo after the order by clauseEo after the where clause5)in a select statement that includes a where clause, where is
5、the order by clause placed in the select statement?eAo immediately after the select clauseBo before the where clauseCo after all clauseDo after the where clauseE, before the from clause6)evaluate there two sql statements。Select last_name, salary from employees order by salary;Select last_namet salar
6、y from employees order by 2 asc;Ao the same result Bo different result Co the second statement returns a syntax error7) you would like to display the system date in the format 20211110 14： 44： 17 o Which select statement should you use?OAoselectto_date(sydate,yearmmdd hh：mm：ss* )from dual;Boselectto
7、_char(sydate,yearmonthday hh:mi:ss )from dual;Coselectto-date(sydateyyyymmdd hh24：mi：ss )from dual;Doselectto-char(sydate,yyyymmdd hh24：mi：ss )from dual;Eoselectto-char(sydate yy-mm-dd hh24：mi：ss， )from dual;8)which select statement will the result 4ello world , from the string Hello world* ?。Ao sel
8、ect substr( 4Hello World* , l)from dual;Bo select substr(trim( Hello World, , 1, l)from dual;Co select lower(substr( * Hello World, 1)from dual;Do select lower(trim( H from Hello World )from dual;9)which are DML statements(choose all that apply)Amit Bo merge Co update Do delete E。 creat F。 drop10)Select语句中用来连接字符串的符号是_C,Ao + ” Bo & CoDo ”感谢您的阅读，祝您生活愉快。