单选题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

题目
单选题
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.The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

2.以下哪条SELECT语句将返回一个数字值？（）A、SELECT SYSDATE + 600 / 24  FROM 雇员；B、SELECT ROUND（聘用日期， DAY）  FROM 雇员；C、SELECT （SYSDATE - 聘用日期） / 7  FROM 雇员；D、SELECT SYSDATE - 7  FROM 雇员；

3.查询出EMP表中1982年及以后入职的员工信息（）（注：字段hiredate为入职日期，数据类型为DATE型）A、select * from emp where hiredate>='19820101';B、select * from emp where hiredate>=to_char('19820101','YYYYMMDD');C、select * from emp where to_date(hiredate,'YYYYMMDD')>='19820101';D、select * from emp where to_char(hiredate,'YYYYMMDD')>='19820101';

4.显示本月月末的日期()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;

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题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”相关问题

  • 第1题：

    变量v_time=’23-MAY-00’， 如下那条语句返回值为’01-JAN-00’？（）

    • A、select round（v_time，’DAY’） from dual
    • B、select round（v_time，’YEAR’） from dual
    • C、select round（v_time，’MONTH’） from dual
    • D、A select round（to_char（v_time，’yyyy’）） from dual

    正确答案:A

  • 第2题：

    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;

    正确答案:B,C,D

  • 第3题：

    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;

    正确答案:A

  • 第4题：

    如何显示今天是星期几（周一到周日，分别用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;

    正确答案:D

  • 第5题：

    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;

    正确答案:C

  • 第6题：

    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;

    正确答案:A

  • 第7题：

    Which SQL statement returns a numeric value?（）

    • A、SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
    • B、SELECT ROUND(hire_date) FROM EMP;
    • C、SELECT sysdate-hire_date FROM EMP;
    • D、SELECT TO_NUMBER(hire_date + 7) FROM EMP;

    正确答案:C

  • 第8题：

    单选题
    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, 'YYY')   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;


    正确答案： C
    解析： 暂无解析

  • 第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;


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    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;


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    变量v_time=’23-MAY-00’， 如下那条语句返回值为’01-JAN-00’？（）
    A

    select round（v_time，’DAY’） from dual

    B

    select round（v_time，’YEAR’） from dual

    C

    select round（v_time，’MONTH’） from dual

    D

    A select round（to_char（v_time，’yyyy’）） from dual


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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;


    正确答案： A
    解析： 暂无解析

  • 第13题：

    显示本月月末的日期（）

    • 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;

    正确答案:C

  • 第14题：

    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 HH:MI:SS AM') NEW _ DATE FROM dual;
    • C、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth "of" Month YYYY NEW _ DATE FROM dual;
    • D、SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth "of" Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual;

    正确答案:A

  • 第15题：

    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;

    正确答案:B,C,D

  • 第16题：

    查询出当前的数据库系统时间，精确到秒（）

    • 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;

    正确答案:B

  • 第17题：

    The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）

    • A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
    • B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
    • C、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
    • D、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

    正确答案:C

  • 第18题：

    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;

    正确答案:E

  • 第19题：

    单选题
    如何显示今天是星期几（周一到周日，分别用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;


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    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 HH:MI:SS AM') NEW _ DATE FROM dual;

    C

    SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY NEW _ DATE FROM dual;

    D

    SELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY), 'fmDdspth of Month YYYYfmtHH:HI:SS AM')NEW_DATE FROM dual;


    正确答案： D
    解析： 暂无解析

  • 第21题：

    多选题
    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;


    正确答案： A,D
    解析： 暂无解析

  • 第22题：

    单选题
    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;


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    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;


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    查询出当前的数据库系统时间，精确到秒（）
    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;


    正确答案： C
    解析： 暂无解析

相关内容