itgle.com

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

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

相似考题

1.有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

2.Select ‘accp’ from dual后运行结果是()。A.nullB.0C.accpD.编译出错

3.有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

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;

更多“多选题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”相关问题

  • 第1题：

    显示本月月末的日期（）

    • 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

  • 第2题：

    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

  • 第3题：

    取出工资在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;

    正确答案:D

  • 第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题：

    单选题
    取出工资在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;


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

  • 第7题：

    单选题
    对于雇员表（EMP）中的员工薪水（SAL）进行分级，3000元以上的为A级，2000元以上到3000元为B级，2000元及以下为C级，以下哪此操作能实现以上要求（）
    A

    select sal,decode(sal>3000,'A',sal>2000,'B','C') grade from emp;

    B

    select sal,decode(sal,3000,'A',2000,'B','C') grade from emp;

    C

    select sal,(case when sal>3000 then 'A' when sal>2000 then 'B' else 'C' end) grade from emp;

    D

    select sal,(if sal>3000 then 'A' elsif sal>2000 then 'B' else 'C' end if) grade from emp;


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

  • 第8题：

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

  • 第9题：

    单选题
    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?（）
    A

    SELECT * FROM t1 UNION SELECT * FROM t2

    B

    SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2

    C

    SELECT * FROM t1 INTERSECT SELECT * FROM t2

    D

    SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)


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

  • 第10题：

    多选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第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题：

    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

  • 第14题：

    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

  • 第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题：

    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

  • 第18题：

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


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

  • 第19题：

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


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

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    显示本月月末的日期（）
    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
    解析： 暂无解析

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    多选题
    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? （）
    A

    SELECT customer_id, order_id, order_total FROM orders RANGE ON order _ total (100 AND 2000) INCLUSIVE;

    B

    SELECT customer_id, order_id, order_total FROM orders HAVING order _ total BETWEEN 100 and 2000;

    C

    SELECT customer_id, order_id, order_total FROM orders WHERE order _ total BETWEEN 100 and 2000;

    D

    SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and <= 2000;

    E

    SELECT customer_id, order_id, order_total FROM orders WHERE order_total>= 100 and order_total <= 2000;


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

  • 第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
    解析： 暂无解析

相关内容