网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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 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;” 相关考题
考题
显示本月月末的日期()
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 * FROM教师WHERE NOT（工资3000 OR 工资2000）与如上语句等价的SQL语句是A．SELECT*FROM 教师 HWERE 工资 BETWEEN 2000 AND 3000B．SELECT*FROM 教师 HWERE 工资 2000 AND 工资3000C．SELECT*FROM 教师 HWERE 工资2000 OR 工资3000D．SELECT*FROM 教师 HWERE 工资=2000 AND 工资=3000
考题
查询出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;
考题
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;
考题
单选题取出工资在2000到3000元（包括上下限）之间的员工（）A
select * from emp wher sal in (2000,3000);B
select * from emp wher sal like (2000,3000);C
select * from emp wher sal = (2000,3000);D
select * from emp wher sal between 2000 and 3000;
考题
单选题The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this? （）A
SELECT AVERAGE(gpa) FROM student_grades WHERE semester _ end '01-JAN-2000' and semester end 31-DEC-2000';B
SELECT COUNT(gpa) FROM student grades WHERE semester _ end '01-JAN-2000' and semester end 31-DEC-2000';C
SELECT MIN(gpa) FROM student grades WHERE semester _ end '01-JAN-2000' and semester end 31-DEC-2000';D
SELECT AVG(gpa) FROM student_grades WHERE semester _ end BETWEEN '01-JAN-2000' and '31-DEC-2000';E
SELECT SUM(gpa) FROM student grades WHERE semester _ end '01-JAN-2000' and semester end 31-DEC-2000';F
SELECT MEDIAN(gpa) FROM student_grades WHERE semester _ end '01-JAN-2000' and semester end 31-DEC-2000';
考题
单选题对于雇员表（EMP）中的员工薪水（SAL）进行分级，3000元以上的为A级，2000元以上到3000元为B级，2000元及以下为C级，以下哪此操作能实现以上要求（）A
select sal,decode(sal3000,'A',sal2000,'B','C') grade from emp;B
select sal,decode(sal,3000,'A',2000,'B','C') grade from emp;C
select sal,(case when sal3000 then 'A' when sal2000 then 'B' else 'C' end) grade from emp;D
select sal,(if sal3000 then 'A' elsif sal2000 then 'B' else 'C' end if) grade from emp;
考题
多选题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;
考题
单选题如何显示今天是星期几（周一到周日，分别用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;
考题
单选题显示本月月末的日期（）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;
考题
单选题查询出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';
考题
单选题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 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
考题
多选题The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_TOTAL NUMBER(10,2) The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? （）ASELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;BSELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;CSELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;DSELECT customer_id, order_id, order_total FROM orders WHERE order_total= 100 and = 2000;ESELECT customer_id, order_id, order_total FROM orders WHERE order_total= 100 and order_total = 2000;
考题
单选题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;
热门标签
最新试卷
