单项选择题
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
点击查看答案&解析
相关考题
-
多项选择题
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? （）
A.INSERT INTO employees VALUES ( NULL, 'John', 'Smith');
B.INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');
C.INSERT INTO employees VALUES ( '1000', 'John', NULL);
D.INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');
E.INSERT INTO employees (employee_id) VALUES (1000);
F.INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
