欢迎来到建筑考试题库网 建筑考试题库官网
全部科目 > Oracle认证考试 > 1Z0-007

单项选择题

Evaluate the SQL statement:SELECT ROUND(TRUNC(MOD(1600,10),-1),2)FROM dual;What will be displayed?()

    A.0
    B.1
    C.0.00
    D.an error statement

点击查看答案

相关考题

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

  • 单项选择题
    In which scenario would an index be most useful?()

    A.The indexed column is declared as NOT NULL.
    B.The indexed columns are used in the FROM clause.
    C.The indexed columns are part of an expression.
    D.The indexed column contains a wide range of values.

  • 单项选择题
    A subquery can be used to().

    A.create groups of data
    B.sort data in a specific order
    C.convert data to a different format
    D.retrieve data based on an unknown condition

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题