单选题Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A 0B 1C 0.00D An error statement

第1题：

第2题：

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

第3题：

The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）

• A、All of the desired results
• B、Two of the desired results
• C、One of the desired results
• D、An error statement

第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题：

Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）

• A、16 
• B、100 
• C、160 
• D、200 
• E、150

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement? （）

• A、The statement produces an error at line 1.
• B、The statement produces an error at line 3.
• C、The statement produces an error at line 6.
• D、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.
• E、The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

第15题：

Evaluate this SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if you remove all the parentheses from the calculation? （）

• A、The value displayed in the CALC_VALUE column will be lower.
• B、The value displayed in the CALC_VALUE column will be higher.
• C、There will be no difference in the value displayed in the CALC_VALUE column.
• D、An error will be reported.

第16题：

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

第17题：

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

第18题：

Which SELECT statement will the result ‘ello World’ from the string ‘Hello World’?（）

• A、SELECT SUBSTR( ‘Hello World’,1) FROM dual;
• B、SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;
• C、SELECT LOWER(SUBSTR(‘Hello World’, 1, 1) FROM dual;
• D、SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;
• E、SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：