单选题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题：

Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）

• A、Selection, projection, join
• B、Difference, projection, join
• C、Selection, intersection, join
• D、Intersection, projection, join
• E、Difference, projection, product

第2题：

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;

第3题：

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.

第4题：

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;

第5题：

Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）

• A、SELECT * FROM emp_dept_vu;
• B、SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
• C、SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
• D、SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000
• E、None of the statements produce an error; all are valid.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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;

第15题：

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.

第16题：

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.

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

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：