單項(xiàng)選擇題

Evaluate the SQL statement:
SELECT ROUND(45.953, -1), TRUNC(45.936, 2)
FROM dual;
Which values are displayed?（）

A. 46 and 45
B. 46 and 45.93
C. 50 and 45.93
D. 50 and 45.9
E. 45 and 45.93
F. 45.95 and 45.93

你可能感興趣的試題

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?（）

A. SELECT &1, "&2" FROM &3 WHERE last_name = '&8';
B. SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';
C. SELECT &1, &2 FROM &3 WHERE last_name = '&8';
D. SELECT &1, '&2' FROM EMP WHERE last_name = '&8';

多項(xiàng)選擇題

From SQL*Plus, you issue this SELECT statement:

You use this statement to retrieve data from a data table for（）。

A. Updating
B. Viewing
C. Deleting
D. Inserting
E. Truncating

Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?（）

你可能感興趣的試題

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition?（）

From SQL*Plus, you issue this SELECT statement: You use this statement to retrieve data from a data table for（）。

Evaluate the SQL statement:
SELECT ROUND(45.953, -1), TRUNC(45.936, 2)
FROM dual;
Which values are displayed?（）

From SQL*Plus, you issue this SELECT statement:

You use this statement to retrieve data from a data table for（）。