神州数码笔试题和面试题答案目(3)

招聘笔试题2018-11-22王新老师

  7) 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’?______。

  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 statements(choose all that apply)______。

相关推荐

猜你喜欢

大家正在看

换一换