單項(xiàng)選擇題

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;

你可能感興趣的試題

單項(xiàng)選擇題

Which statement describes the ROWID data type?（）

A. Binary data up to 4 gigabytes.
B. Character data up to 4 gigabytes.
C. Raw binary data of variable length up to 2 gigabytes.
D. Binary data stored in an external file, up to 4 gigabytes.
E. A hexadecimal string representing the unique address of a row in its table.

單項(xiàng)選擇題

Evaluate these two SQL statements:

What is true about them?（）

A. The two statements produce identical results.
B. The second statement returns a syntax error.
C. There is no need to specify DESC because the results are sorted in descending order by default.
D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

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

你可能感興趣的試題

Which statement describes the ROWID data type?（）

Evaluate these two SQL statements: What is true about them?（）

Evaluate these two SQL statements:

What is true about them?（）