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.00B、17000*****C、****170.00D、**17000.00E、an error statement

第1题：

第2题：

Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）

• A、SELECT last_name, 12*salary* commission_pct FROM emp;
• B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
• C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
• D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

第3题：

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.

第4题：

Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; 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.

第5题：

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.

第6题：

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

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"? （）

• A、No change is required to achieve the desired results.
• B、SELECT ename, sal, 12* (sal+100) FROM emp;
• C、SELECT ename, sal, (12* sal)+100 FROM emp;
• D、SELECT ename, sal +100,*12 FROM emp;

第14题：

Evaluate this SQL statement: 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.

第15题：

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?（）

• A、SELECT dept_id, MIN(salary(, MAX(salary) FROM employees WHERE MIN(salary) <5000 AND MAX (salary) > 15000;
• B、SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) < 5000 AND MAX(salary) > 15000 GROUP BY dept_id;
• C、SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) <5000 AND MAX (salary) > 15000;
• D、SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN (salary) < 5000 AND MAX(salary)
• E、SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN (salary) <5000 AND MAX (salary) > 15000;

第16题：

Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 HR_MGR 5000 106 Bryan 40 110 AD_ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EX_DIR 8000 120 Ravi 20 110 SA_DIR 6500 Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?（）

• A、SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;
• B、SELECT e.employee_id "Emp_id", e.emp_name "Employee",
• C、salary,
• D、employee_id "Mgr_id", m.emp_name "Manager" FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;

第17题：

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

第18题：

Evaluate these two SQL statements:SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; 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.

第19题：

第20题：

第21题：

第22题：

第23题：