网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 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;” 相关考题
考题
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;
考题
显示本月月末的日期()
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;
考题
以下哪条SELECT语句将返回一个数字值？（）A、SELECT SYSDATE + 600 / 24 FROM 雇员；B、SELECT ROUND（聘用日期， DAY） FROM 雇员；C、SELECT （SYSDATE - 聘用日期） / 7 FROM 雇员；D、SELECT SYSDATE - 7 FROM 雇员；
考题
查询出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';
考题
变量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 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;
考题
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;
考题
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;
考题
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;
考题
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;
考题
单选题如何显示今天是星期几（周一到周日，分别用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;
考题
单选题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;
考题
单选题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
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 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 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;
考题
单选题变量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
考题
单选题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;
考题
单选题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
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;
热门标签
最新试卷