[单选] Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）  

Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error?（） remove the ORDER BY clause。 remove the table alias prefix from the WHERE clause。 remove the table alias from the SELECT clause。 prefix the column in the USING clause with the table alias。 prefix the column in the ORDER BY clause with the table alias。 replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"。 巡视人员负责机房环境安全检查和放置有效的（）、绝缘垫、挂有进入机房的基站故障处理流程图、灭火流程图及各类警示牌 梯子。 灭火器。 水桶。 清洁工具。 A server has two PCI-X buses with four Active PCI-X slots.  Slots 1 and 2 are on the first PCI-X bus （100MHz） and slots 3 and 4 are on the second PCI-X bus （133MHz）. The customer requires you to install adapter A and adapter B on day one.  After the server has been installed and configured， the server must  be running 24 by 7 with no downtime. Three months later， adapter C needs to be hot added. All the adapters are 64-bit and capable of speeds up to 133MHz.  The customer’s priority is to have no downtime， and performance is secondary.   Based on the information provided， into which slots should adapters A and B be installed in and later into which slot would adapter C be hot-added？（） Adapter A in slot 1， adapter B in slot 4 and hot-add adapter C in slot 3。 Adapter A in slot 1， adapter B in slot 3 and hot-add adapter C in slot 2。 Adapter A in slot 2， adapter B in slot 4 and hot-add adapter C in slot 3。 Adapter A in slot 3， adapter B in slot 1 and hot-add adapter C in slot 4。 User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *  ERROR at line 1：  ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（） Grant the RESOURCE role to SCOTT.。 Add data files to the USERS tablespace.。 Grant the CREATE ANY TABLE privilege to SCOTT.。 Increase the space for SCOTT on the USERS tablespace.。 Increase the size of the data file associated with the USERS tablespace。 耕地总量动态平衡 Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）