问题

Which SQL statement displays the date

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

参考答案

参考解析：

分类：1Z0-007题库

Which three SELECT statements displays 2000 in the format “$2,000.00”?（）A SELECT TO CNAR(2000, ‘$#,###.##’) FROM dual;B SELECT...

2、Which SQL statement defines the FOREIG

Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? （）A CREATE TABLE EMP (empno NUMBER(4), ename V...

3、Which of the following SQL statements

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

4、Which SQL statement returns a numeric

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

5、Which SQL statement defines a FOREIGN

Which SQL statement defines a FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）ACREATE TABLE EMP (empno NUMBER(4), ename VARCHAR...

6、Which three SELECT statements displays

Which three SELECT statements displays 2000 in the format "$2,000.00"? （）A SELECT TO CNAR(2000, '$#,###.##') FROM dual;B SELECT TO CNAR(...

编辑推荐

患者，女，28岁，晨起恶心、呕吐2天，停经50天。最可能的诊断.....

胰腺癌的好发部位是（）..

在PRS700电源系统中，要进行下列维护工作或了解下列信息，应.....

每簇中小区数目越多，载干比C/I越小，网络质量越好，但频率利.....

国务院银行业监督管理机构对中国人民银行提出的检查银行业金.....

织物能够正常被穿用，就必须具有一定的（）。..