MemoDate: January 15, 2002To: Employees in Research and Development DepartmentFrom: Mary S

第1题

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2（25)LAST_NAME VARCHAR2（25)HIRE_DATE DATEWhich INSERT statement is valid？（）

A. INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, ‘John‘, ‘smith‘,‘01/01/01);

B. INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, ‘John‘, ‘smith‘,‘01 january 01‘);

C. INSERT INTO employees(employee_id, first_name, last_name, Hire_date) VALUES (1000, ‘John‘, ‘smith‘, To_ date (‘01/01/01));

D. INSERT INTO employees(employee_id, first_name, last_name, hire_date) VALUES (1000, ‘John‘, ‘smith‘,‘01-Jan-01‘);

点击查看答案

第2题

Task 2Directions: This task is the same as Task 1.The 5 questions or unfinished statements

Task 2

Directions: This task is the same as Task 1. The 5 questions or unfinished statements are numbered 41 through 45.

Memo

Date: January 15, 2002

To: Employees in Research and Development Department

From: Mary Silvers, Project Manager

Re: New Flex-Time Policy Beginning March 1, 2002

The company is offering a new flex-time schedule to all employees. You must sign up for this plan by Feb. 20, 2006, in order to use it.

Components of the Plan

Employees must agree to:

* Work 40 hours a week (except normal vacation time, sick leave, or holiday weeks)

* Work a minimum of 4 days a week

* Work no more than 12 hours a day

* Arrive at work no later than 9:30 a. m.

* Leave work no earlier than 3: 30 p. m. (unless you have completed 40 hours that week)

Scheduling Considerations

Employees may schedule work time as long as it fits the above criteria.

Employees who sign up for this new flex time scheduling must declare their work hours during the previous week.

The supervisor will take responsibility for recording each employee's work schedule.

Employees who wish to try this new plan must stay on it for three months before returning to the current policy.

Employees who may want to start it later, must wait until January of the next calendar year to sign up.

Important Reminder

Remember—Sign up by Feb. 20 to take advantage of the new Flex-Time schedule.

The memo is about

A．the employees will take responsibility for recording each employees work schedule

B．supervisor who may want to start it later, must wait until January of the next calendar

C．New Flex-Time Policy Beginning March 1, 2002

D．employers may schedule work time as long as it fits the above criteria

点击查看答案

第3题

Task 2Directions: This task is the same as Task 1.The 5 questions or unfinished statements

Task 2

Directions: This task is the same as Task 1. The 5 questions or unfinished statements are numbered 41 through 45.

Memo

Date: January 15, 2002

To: Employees in Research and Development Department

From: Mary Silvers, Project Manager

Re: New Flex-Time Policy Beginning March 1, 2002

The company is offering a new flex-time schedule to all employees. You must sign up for this plan by Feb. 20, 2006, in order to use it.

Components of the Plan

Employees must agree to:

* Work 40 hours a week(except normal vacation time, sick leave, or holiday weeks)

* Work a minimum of 4 days a week

* Work no more than 12 hours a day

* Arrive at work no later than 9:30 a.m.

* Leave work no earlier than 3:30 p.m.(unless you have completed 40 hours that week)

Scheduling Considerations

Employees may schedule work time as long as it fits the above criteria.

Employees who sign up for this new flex time scheduling must declare their work hours during the previous week.

The supervisor will take responsibility for recording each employee's work schedule.

Employees who wish to try this new plan must stay on it for three months before returning to the current policy.

Employees who may want to start it later, must wait until January of the next calendar year to sign up.

Important Reminder

Remember—Sign up by Feb. 20 to take advantage of the new Flex-Time schedule.

The memo is about

A．the employees will take responsibility for recording each employees work schedule

B．supervisor who may want to start it later, must wait until January of the next calendar

C．New Flex-Time Policy Beginning March 1, 2002

D．employers may schedule work time as long as it fits the above criteria

点击查看答案

第4题

A．On January 8th.B．On January 9th.C．On January 11th.D．On January 12th.

A．On January 8th.

B．On January 9th.

C．On January 11th.

D．On January 12th.

点击查看答案

第5题

We （) have thirty full-time and 15 part-time employees in our company.

A．currently

B．for

C．yesterday

D．Internationally

点击查看答案