单选题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_CH

第1题：

Given the following function: CREATE FUNCTION emplist （　） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?

• A、SELECT TABLE(EMPLIST()) FROM EMPLOYEE
• B、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
• C、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
• D、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

第2题：

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;

第3题：

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;

第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;

第5题：

查询出当前的数据库系统时间，精确到秒（）

• 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;

第6题：

The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? （）

• A、SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
• B、SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
• C、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
• D、SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

第7题：

You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）

• A、SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date;
• B、SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;
• C、SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;
• D、SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

第8题：

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;

第9题：

第10题：

第11题：

第12题：

第13题：

显示本月月末的日期（）

• 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;

第14题：

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;

第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;

第16题：

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）

• A、SELECT ename, salary*12 'Annual Salary' FROM employees;
• B、SELECT ename, salary*12 "Annual Salary" FROM employees;
• C、SELECT ename, salary*12 AS Annual Salary FROM employees;
• D、SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees

第17题：

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;

第18题：

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;

第19题：

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;

第20题：

第21题：

第22题：

第23题：

第24题：