单选题Evaluate the SQL statement:SELECT ROUND(45.953, -1), TRUNC(45.936, 2)FROM dual;Which values are displayed?（）A 46 and 45B 46 and 45.93C 50 and 45.93D 50 and 45.9E 45 and 45.93F 45.95 and 45.93

第1题：

第2题：

第3题：

第4题：

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

第5题：

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;

第6题：

第7题：

Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）

• A、17000.00
• B、17000*****
• C、****170.00
• D、**17000.00
• E、an error statement

第8题：

第9题：

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;

第10题：

Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）

• A、0
• B、1
• C、0.00
• D、An error statement