Select ‘accp’ from dual后运行结果是（）。A、nullB、0C、accpD、编译出错
Select ‘accp’ from dual后运行结果是（）。
- A、null
- B、0
- C、accp
- D、编译出错
相关考题：
语句select LAST_DAY(‘2011－05－01’)from dual;的结果是()。 A.2011-05-28B.2011-05-31C.2011-04-30D.2011-05-07
语句select ROUND(45.953,－1),TRUNC(45.936,2)from dual;的结果是()。 A.46 and 45B.46 and 45.93C.50 and 45.93D.50 and 45.9
显示本月月末的日期() 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;
在Oracle中，有一个名为seq的序列对象，以下语句能返回序列值但不会引起序列值增加的是（）A、select seq.ROWNUM from dualB、select seq.ROWID from dualC、select seq.CURRVAL from dualD、select seq.NEXTVAL from dual
You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use? （）A、SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;B、SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;C、SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;D、SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;E、SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
变量v_time=’23-MAY-00’， 如下那条语句返回值为’01-JAN-00’？（）A、select round（v_time，’DAY’） from dualB、select round（v_time，’YEAR’） from dualC、select round（v_time，’MONTH’） from dualD、A select round（to_char（v_time，’yyyy’）） from dual
显示本月月末的日期（）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;
Which three SELECT statements displays 2000 in the format "$2,000.00"? （）A、SELECT TO CNAR(2000, '$#,###.##') FROM dual;B、SELECT TO CNAR(2000, '$0,000.00') FROM dual;C、SELECT TO CNAR(2000, '$9,999.00') FROM dual;D、SELECT TO CNAR(2000, '$9,999.99') FROM dual;E、SELECT TO CNAR(2000, '$2,000.00') FROM dual;F、SELECT TO CNAR(2000, '$N,NNN.NN') FROM dual;
Which three SELECT statements display 2000 in the format "$2,000.00"? （）A、SELECT TO_CHAR(2000, '$#,###.##') FROM dual;B、SELECT TO_CHAR(2000, '$0,000.00') FROM dual;C、SELECT TO_CHAR(2000, '$9,999.00') FROM dual;D、SELECT TO_CHAR(2000, '$9,999.99') FROM dual;E、SELECT TO_CHAR(2000, '$2,000.00') FROM dual;F、SELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;
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;
如何显示今天是星期几（周一到周日，分别用1~7表示）（）A、select to_char(sysdate,'D') from dual;B、select to_char(sysdate,'W') from dual;C、select to_char(sysdate,'D')-1 from dual;D、select to_char(sysdate-1,'D') from dual;E、select to_char(sysdate-1,'W') from dual;
查询出当前的数据库系统时间，精确到秒（）A、select to_date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;B、select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;C、select date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;D、select chr(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A、0B、1C、0.00D、An error statement
Evaluate the following query: SQL SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A、16 B、100 C、160 D、200 E、150
Which SQL statement displays the date March 19, 2001 in a format that appears as "Nineteenth of March 2001 12:00:00 AM"?（）A、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;B、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth "of" Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;C、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY HH:MI:SS AM') NEW_DATE FROM dual;D、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmtDdspth "of" Month YYYY fmtHH:MI:SS AM') NEW_DATE FROM dual;
Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）A、SELECT SUBSTR( ‘Hello World’,1) FROM dual;B、SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;C、SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;D、SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;E、SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;
语句select ROUND（45.953，-1），TRUNC（45.936，2）from dual；的结果是（）。A、46 and 45B、46 and 45.93C、50 and 45.93D、50 and 45.9
单选题语句select ROUND（45.953，-1），TRUNC（45.936，2）from dual；的结果是（）。A46 and 45B46 and 45.93C50 and 45.93D50 and 45.9
单选题Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）ASELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;BSELECT TO_DATE(SYSDATE,'yyyy') FROM dual;CSELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;DSELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;ESELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
多选题Which three SELECT statements display 2000 in the format "$2,000.00"? （）ASELECT TO_CHAR(2000, '$#,###.##') FROM dual;BSELECT TO_CHAR(2000, '$0,000.00') FROM dual;CSELECT TO_CHAR(2000, '$9,999.00') FROM dual;DSELECT TO_CHAR(2000, '$9,999.99') FROM dual;ESELECT TO_CHAR(2000, '$2,000.00') FROM dual;FSELECT TO_CHAR(2000, '$N,NNN.NN') FROM dual;
多选题Which three SELECT statements displays 2000 in the format "$2,000.00"? （）ASELECT TO CNAR(2000, '$#,###.##') FROM dual;BSELECT TO CNAR(2000, '$0,000.00') FROM dual;CSELECT TO CNAR(2000, '$9,999.00') FROM dual;DSELECT TO CNAR(2000, '$9,999.99') FROM dual;ESELECT TO CNAR(2000, '$2,000.00') FROM dual;FSELECT TO CNAR(2000, '$N,NNN.NN') FROM dual;
单选题语句select LAST_DAY（‘2011-05-01’）from dual；的结果是（）。A2011-05-28B2011-05-31C2011-04-30D2011-05-07
单选题You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use? （）ASELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;BSELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;CSELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;DSELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;ESELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
单选题Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）ASELECT SUBSTR( ‘Hello World’,1) FROM dual;BSELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;CSELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;DSELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;ESELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;