搜题
用户您好, 请在下方输入框内搜索其它题目:
搜题
题目内容 (请给出正确答案)
提问人:网友 发布时间:
【单选题】

语句select LAST_DAY(‘2011-05-01’)from dual;的结果是()。

A、2011-05-28

B、2011-05-31

C、2011-04-30

D、2011-05-07

更多“语句select LAST_DAY(‘2011-05-01’)from dual;的结果是()。”相关的问题
第1题

A、select last_date(sysdate) from dual;  B、select finally_day(sysdate) from dual;  C、select last_day(sysdate) from dual;  D、select tail_day(sysdate) from dual;  

点击查看答案
第2题

A、FREQ = MONTHLY; BYMONTHDAY = 31  B、FREQ = MONTHLY; BYMONTHDAY = -1  C、FREQ = DAILY; BYDAY = -1  D、FREQ = MONTHLY; BYDAY = 31  E、FREQ = DAILY; BYMONTHDAY = LAST_DAY  

点击查看答案
第3题

A、A.SELECT last_name,12*salary* commission_pct FROM emp  B、B.SELECT last_name,12*salary*(commission_pct,0)FROM emp  C、C.SELECT last_name,12*salary*(nvl(commission_pct,0))FROM emp如果oracle第一个参数为空那么显示第二个参数的值,如果第一个参数的值不为空,则显示第一个参数本来的值  D、D.SELECT last_name,12*salary*(decode(commission_pct,0))FROM emp  

点击查看答案
第4题

A、SELECT &1, "&2" FROM &3 WHERE last_name = '&8';  B、SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';  C、SELECT &1, &2 FROM &3 WHERE last_name = '&8';  D、SELECT &1, '&2' FROM EMP WHERE last_name = '&8';  

点击查看答案
第5题

A、SELECT &1, "&2" FROM &3 WHERE last_name = '&4';  B、SELECT &1, '&2' FROM &3 WHERE '&last_name = '&4'';  C、SELECT &1, &2 FROM &3 WHERE last_name = '&4';  D、SELECT &1, '&2' FROM EMP WHERE last_name = '&4';  

点击查看答案
第6题

A、A. SELECT &1, "&2" FROM &3 WHERE last_name = '&8';  B、B. SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';  C、C. SELECT &1, &2 FROM &3 WHERE last_name = '&8';  D、D. SELECT &1, '&2' FROM EMP WHERE last_name = '&8';  

点击查看答案
第7题

A、 FREQ = MONTHLY; BYMONTHDAY = 31  B、 FREQ = MONTHLY; BYMONTHDAY = -1  C、 FREQ = DAILY; BYDAY = -1  D、 FREQ = MONTHLY; BYDAY = 31  E、 FREQ = DAILY; BYMONTHDAY = LAST_DAY  

点击查看答案
第8题

A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';  B、SELECT last_name FROM EMP WHERE last name ='*A%'  C、SELECT last_name FROM EMP WHERE last name ='_A%';  D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'  

点击查看答案
第9题

A、SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';  B、SELECT last_name FROM EMP WHERE last name ='*A%'  C、SELECT last_name FROM EMP WHERE last name ='_A%';  D、SELECT last_name FROM EMP WHERE last name LIKE '*A%'  

点击查看答案
客服
TOP

请使用微信扫码支付

订单号:
遇到问题请联系在线客服