第1题:
According to Federal health officials ,the fact that more West Nile cases have been reported indicates that
[A] more states are affected.
[B] the average age dropped drastically.
[C] health officials are more alert to the disease.
[D] the epidemic season began a month earlier.
第2题:

A. To find the tax percentage for each of the employees.
B. To list the name, job id, and manager name for all the employees.
C. To find the name, salary, and department name of employees who are not working with Smith.
D. To find the number of employees working for the Administrative department and earning less then 4000.
E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
第3题:

A.to find the tax percentage for each of the employees
B.to list the name, job_id, and manager name for all the employees
C.to find the name, salary, and the department name of employees who are not working with Smith
D.to find the number of employees working for the Administrative department and earning less than 4000
E.to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned
第4题:
第5题:
第6题:
第7题:
第8题:
6.0
6.2
6.4
6.6
6.8
第9题:
第10题:
750 and 850
850 and 950
950 and 1050
第11题:
第12题:
Companies that reimburse outside childcare programs actually see less absenteeism among working parents than companies within·house programs.
In-house childcare programs create distractions for nonparents that cart harm their productivity.
Absenteeism is not a serious problem for companies that impose harsh penalties on employees who miss work.
Studies have shown that employees with children are more likely than those without children to remain in the same job for more than five years.
Potential employees generally view companies with in-house childcare programs as more desirable places to work than companies without such programs.
第13题:
此题为判断题(对,错)。
第14题:
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)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.
B.
C.
D.
E.
第15题:
Click the Exhibit button and examine the data from the EMP table.The COMMISSION column shows the monthly commission earned by the employee.Which two tasks would require subqueries or joins in order to be performed in a single step? ()

A.listing the employees who earn the same amount of commission as employee 3
B.finding the total commission earned by the employees in department 10
C.finding the number of employees who earn a commission that is higher than the average commission of the company
D.listing the departments whose average commission is more than 600
E.listing the employees who do not earn commission and who are working for department 20 in descending order of the employee ID
F.listing the employees whose annual commission is more than 6000
第16题:
第17题:
第18题:
第19题:
offering some employees more and the other less.
relating the customers to the employees’ benefits.
varying benefits according to different employees.
dividing employees into different groups.
第20题:
第21题:
saving employees’ money
making employees more attractive
improving employees’ motivation
making employees happier
第22题:
m
4/3m
3/2m
5/3m
2m
第23题:
On average, less-productive employees spend no fewer hours per day at their workstations than do their more-productive peers.
Unpleasant surroundings give employees less motivation to work hard than more pleasant surroundings do.
The more-productive employees are generally rewarded with pleasant office space.
More-productive employees do not work any more hours than their less-productive peers.
Peer pressure discourages employees in crowded, unpleasant surroundings from making phone calls to their own family members during work time.