多选题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;
多选题
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;
参考解析
解析：
暂无解析
相关考题：
有SQL语句： SELECT*FROM教师WHERENOT(工资＞30000R工资＜2000)与如上语句等价的SQL语句是A．SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B．SELECT*FROM 教师 WHERE 工资＞2000 AND工资＜3000C．SELECT*FROM 教师 WHERE 工资＞2000 OR工资＜3000D．SELECT*FROM 教师 WHERE 工资＜=2000 AND工资＞3000
显示本月月末的日期() 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
显示本月月末的日期（）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;
取出工资在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;
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元（包括上下限）之间的员工（）Aselect * from emp wher sal in (2000,3000);Bselect * from emp wher sal like (2000,3000);Cselect * from emp wher sal = (2000,3000);Dselect * 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? （）ASELECT AVERAGE(gpa) FROM student_grades WHERE semester _ end '01-JAN-2000' and semester end 31-DEC-2000';BSELECT COUNT(gpa) FROM student grades WHERE semester _ end '01-JAN-2000' and semester end 31-DEC-2000';CSELECT MIN(gpa) FROM student grades WHERE semester _ end '01-JAN-2000' and semester end 31-DEC-2000';DSELECT AVG(gpa) FROM student_grades WHERE semester _ end BETWEEN '01-JAN-2000' and '31-DEC-2000';ESELECT SUM(gpa) FROM student grades WHERE semester _ end '01-JAN-2000' and semester end 31-DEC-2000';FSELECT 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级，以下哪此操作能实现以上要求（）Aselect sal,decode(sal3000,'A',sal2000,'B','C') grade from emp;Bselect sal,decode(sal,3000,'A',2000,'B','C') grade from emp;Cselect sal,(case when sal3000 then 'A' when sal2000 then 'B' else 'C' end) grade from emp;Dselect 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表示）（）Aselect to_char(sysdate,'D') from dual;Bselect to_char(sysdate,'W') from dual;Cselect to_char(sysdate,'D')-1 from dual;Dselect to_char(sysdate-1,'D') from dual;Eselect 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?（）ASELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;BSELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYY') 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 of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）ASELECT * FROM t1 UNION SELECT * FROM t2BSELECT * FROM t1 UNION DISTINCT SELECT * FROM t2CSELECT * FROM t1 INTERSECT SELECT * FROM t2DSELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
单选题显示本月月末的日期（）Aselect last_date(sysdate) from dual;Bselect finally_day(sysdate) from dual;Cselect last_day(sysdate) from dual;Dselect 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 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 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;
多选题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"?（）ASELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;BSELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'Ddspth of Month YYYY fmHH:MI:SS AM') NEW_DATE FROM dual;CSELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmDdspth of Month YYYY HH:MI:SS AM') NEW_DATE FROM dual;DSELECT TO_CHAR(TO_DATE('19-Mar-2001', 'DD-Mon-YYYY'), 'fmtDdspth of Month YYYY fmtHH:MI:SS AM') NEW_DATE FROM dual;
单选题查询出当前的数据库系统时间，精确到秒（）Aselect to_date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;Bselect to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;Cselect date(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;Dselect chr(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;