问题

Which SELECT statement should you use

Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"? （）

A SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;
B SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;
C SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;
D SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;
E SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual

参考答案

参考解析：

分类：1Z0-007题库

Which three SELECT statements displays 2000 in the format “$2,000.00”?（）A SELECT TO CNAR(2000, ‘$#,###.##’) FROM dual;B SELECT...

2、Which clause should you use to exclude

Which clause should you use to exclude group results? （）A WHEREB HAVINGC RESTRICTD GROUP BYE ORDER BY

3、Which channel and mode should be used

Which channel and mode should be used when initiating a distress alert transmission（）.AChannel 6 DSCBChannel 6 RadiotelephonyCChannel 13 Radiotelephony and channel 16 DSCDChannel 70 DSC

4、Which command should be used to captur

Which command should be used to capture network traffic between the localhost and a host named ‘webserver’?（）Atcpdump webserverBtcpdump host webserverCtcpdump -hostname webserverDtcpdump -print -h webserver

5、Which three SELECT statements displays

Which three SELECT statements displays 2000 in the format "$2,000.00"? （）A SELECT TO CNAR(2000, '$#,###.##') FROM dual;B SELECT TO CNAR(...

6、Which SQL statement would you use to r

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）A DROP emp_dept_uv;B DELETE emp_dept_uv;C REMOVE emp_dept_uv;D DROP VIEW emp_dept_uv;E DELETE VIEW emp_dept_uv;F REMOVE VIEW emp_dept_uv

编辑推荐

顺栿串..

社会救助最基本和最直接的功能是（）..

由于旅游产品生产和消费的同一性，决定率一旦出现质量问题便.....

对于连续操作过程，选用（）作为基准是很自然的。..

（）认为儿童孤独症产生于神经系统的器质性病变、机能障碍、.....

基层医疗卫生机构传染病报告资料的要求（）..