You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use? （） -题库考试答案搜索网

You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use? （）

单选题

2022-01-10 06:28

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;

查看答案

正确答案

试题解析

标签： CMS专题 Oracle认证考试 1Z0-007

感兴趣题目

Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

--What would you like, tea or coffee? --（）

一Whom would you like to be your assistant，Jack or David？一If I had to choose，David would be__________choice.

Would you rather come on Friday or Saturday?（）

Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressedmode for an installation（）

Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressed mode foran installation？（）

— I would like to make an appointment for the meeting. Which day would you prefer, Tuesday or Thursday?

— _________________

Don’t ______ that rope, or you might fall.

---Would you like tea or coffee?
---___ , thanks.( )

Who do you like better, your father or mother? Why?

Do you like an apple or a banana?（）

Do you like your hometown? Why or why not?