[单项选择]The employees working in a small company______.
A. have to study accounting
B. must be experienced
C. have the chance to report directly to their superiors
D. have less responsibilities

[单项选择]Employees working in the hotel should bear in mind that they can never be too polite to the guests.
A. 旅馆的工作人员应以忍字为本，对客人越礼貌越好。
B. 旅馆的工作人员都应牢记在心：对客人再礼貌都不为过。
C. 旅馆员工工作时都应以忍字为本，决不可对客人过于礼貌。
D. 旅馆员工工作时都应时刻铭记：决不可对客人过于礼貌。

[单项选择] A small business with eight employees has just opened their office in a renovated loft in a busy downtown area. The owner of the building does not want to run any additional wiring beyond power, to preserve the historic nature of the building. Because of this stipulation, almost all tenants in the building have chosen to implement wireless. Which of the following should be the FIRST step in setting up this SOHO network?（）
A. Run a wireless site survey
B. Speak to tenants to determine their telephone standards.
C. Install and configure a Gigabit switch.
D. Determine the operating system versions.

[单项选择]After working for six months on end, employees______ to paid-holidays.
A. are entitled
B. are titled
C. are licensed
D. are enabled

[单项选择]Mr. Payne ______. [A] was working in a small town [B] was living in a desert town [C] was spending his holiday in a small town

[单项选择] Examine the data in the EMPLOYEES table. EMPLOYEES 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 IT_ADMIN 5000 106 Smith 40 110 AD.ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EK_DIR 8000 120 Revi 20 110 SA_DIR 6500 On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement: DELETE employee_id, salary, job_id FROM employees WHERE dept_id = 90; Why does the DELETE statement fail when you execute it?（）
A. There is no row with dept_id 90 in the EMPLOYEES table.
B. You cannot delete the JOB_ID column because it is a NOT NULL column.
C. You cannot specify column names in the DELETE clause of the DELETE statement.
D. You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

[单项选择] 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;

[单项选择] EMPLOYEES and DEPARTMENTS data: EMPLOYEES DEMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_I 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 IT_ADMIN 5000 106 Smith 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 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Admin 20 Education 30 IT 40 Human Resources On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID managers and refers to the EMPLOYEE_ID. On the DEPARTMENTS table DEPARTMENT_ID is the primary key. Evaluate this UPDATE statement. UPDATE employees SET mgr_id = (SELECT mgr_id FROM employees WHERE dept_id= (SELECT department_id FROM departments WHERE department_name = 'Administration')), Salary = (SELECT salary FROM employees WHERE emp_name = 'Smith') WHERE job_id = 'IT_ADMIN'; What happens when the statement is executed?（）
A. The statement executes successfully, leaves the manager ID as the existing value, and changes the salary to 4000 for the employees with ID 103 and 105.
B. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 4000 for the employees with ID 103 and 105.
C. The statement executes successfully, changes the manager ID to NULL, and changes the salary to 3000 for the employees with ID 103 and 105.
D. The statement fails because there is more than one row matching the employee name Smith.
E. The statement fails because there is more than one row matching the IT_ADMIN job ID in the EMPLOYEES table.
F. The statement fails because there is no 'Administration' department in the DEPARTMENTS table.

[单项选择]已知下列员工关系表。Employees
A. 员工号
B. 部门
C. 工资
D. 04501
E. 财务
F. 3000
G. 05601
H. 市场
I. 4000
J. 03020
K. 研发
L. 3500

[单项选择]Employees draw their wages and pensions regularly from the bank which is trusted by their employers to handle the______.
A. traits
B. amends
C. trifles
D. transactions

[单项选择]Companies are hiring more foreign employees because ______.
A. they find foreign employees are usually more talented
B. they need original ideas from employees hired overseas
C. they want to expand their business beyond home borders
D. they have difficulty finding qualified personnel at home

[单项选择]Some employees get their paychecks automatically ______in their bank accounts.
A. (A) deposited
B. (B) depositing
C. (C) are deposited
D. (D) deposit

[单项选择]The advantage of employees having foreign language skills is that they can______.
A. better control the whole negotiation process
B. easily find new approaches to met market needs
C. fast-forward their proposals to headquarters
D. easily make friends with businesspeople abroad

[单项选择]The relationship between employers and employees has been studied ______.
A. originally
B. extremely
C. violently
D. intensively