Companies from western countries value modest and humble employees as equally as businesses in the far-eastern areas do.()
Text 3 Employees are often said to be a company's biggest resource.It is equally true that they are its biggest liability.Scarcely a week goes by without a company falling victim to employees-turned-cnemies-or-embarrassments.The most familiar type of enemy within is the fraudster.The Economist Intelligence Unit conducts a regular poll of senior executives on the subject of fraud committed by insiders.Two year ago the poll discovered that about 70%of companies had suffered from at least one instance of fraud,up from 61%in the previous survey.Fraud is often petty.But fraud can also be more harmful:think of former employees setting up rivals using stolen technology and purloined client lists.Even more dangerous is the vandal.Thieves at least have a rational motive.Vandals are driven by a desire for revenge that can know no limit.A company that specialises in corporate investigation gives a detailed account of the story of a British manufacturing company that was under restructuring.A member of the infonnation technology department discovered that his name was on the list of people whose services would no longer be required.He built a"backdoor"into the company's IT system from his home computer and set about causing damage.What can companies do to reduce the threat from these wolves in sheep's clothing?A lot depends on which particular sorts ofwolves you are dealing with.Yet three principles are always worth bearing in mind.The first is that firms need to focus on the people who have the greatest capacity to do harm-those who control the money and information.The more complicated companies become,the harder it is to identify where power really lies.But one thing is clear.The more dependent on information firms get,the more IT specialists can compromise the whole business.The least companies can do is to keep a careful watch on the IT department.The second is that the human touch is still invaluable.Companies can certainly strengthen their hand by installing software that can identify unusual behaviour or monitor e-mail,or by employing professionals to double-check the accounts.The best way to avoid these problems is to treat our employees with respect.The biggest problem with trying to do more with less is that you can end up tuming your biggest resources into your biggest liabilities. The word"liability"（Para.1）suggests_____A.employees may cause problems to the company B.employees are the fortune of the company C.some employees are embarrassed by the company D.the company can rely entirely on employees
点击查看答案
下面哪条语句可以取出薪水最高的前三个人：（）A、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）；B、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM<=3；C、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM<=3；D、SELECT * FROM EMPLOYEES WHERE ROWNUM<=3 ORDER BY SALARY DESC；
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;
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?（）A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?（）A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);C、SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);D、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);E、SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));
Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）A、SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C、SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D、SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E、SELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F、SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which DELETE statement is valid?（）A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_employees);C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name ='Carrey');D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_name ='Carrey');
