语句SELECT‘ACCP’ FROM DUAL 的执行结果是（）。A、ACCPB、XC、编译错D、提示未选中行
语句SELECT‘ACCP’ FROM DUAL 的执行结果是（）。
- A、ACCP
- B、X
- C、编译错
- 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
执行如下sQL语句： SELECT DISTINCT价格FROM图书 WHERE价格一(SELECT MAX(价格)FROM图书) INTO ARRAY arr 则?arr[2]的结果是（ ）。A.23．00B.32．00C.F．D.系统报错
有SQL语句： SELECT DISTINCT 系号 FROM 教师 WHERE 工资=； ALL(SELECT 工资 FROM 教师 WHERE 系号="02") 该语句的执行结果是系号A) "01"和"02" B）"01"和"03" C）"01"和"04" D）"02"和"03"
显示本月月末的日期() 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;
有SQL语句SELECT DISTINCT系号FROM教师WHERE工资=ALL （SELECT工资FROM教师WHERE系号＝\02\）该语句的执行结果是系号A．"01"和"02"B．"01"和"03"C．"01"和"04"D．"02"和"03"
在Oracle中，有一个名为seq的序列对象，以下语句能返回序列值但不会引起序列值增加的是（）A、select seq.ROWNUM from dualB、select seq.ROWID from dualC、select seq.CURRVAL from dualD、select seq.NEXTVAL from dual
语句select LAST_DAY（‘2011-05-01’）from dual；的结果是（）。A、2011-05-28B、2011-05-31C、2011-04-30D、2011-05-07
变量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
评估以下SELECT语句： SELECT SYSDATE+30 FROM dual； 该查询将返回哪个值？（）A、当前日期加30小时B、当前日期加30天C、当前日期加30个月D、不会返回任何值，因为SELECT语句会产生错误
显示本月月末的日期（）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 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;
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;
如何显示今天是星期几（周一到周日，分别用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;
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;
当需要返回当前用户的名字，可以执行如下（）SQL语句。A、SELECT user FROM V$DBAB、SELECT user FROM dualC、SELECT name FROM dualD、SELECT name FROM V$DBA
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
填空题语句“SELECT 成绩表.* FROM 成绩表WHERE 成绩表.成绩(SELECT Avg(成绩表.成绩) FROM 成绩表)”查询的结果是（）。