船上的船员属于三个部门：甲板部、轮机部和事务部。（）A、Seamen on board the ship are in two departments: Deck Department, Engine Department.B、Seaman on board the ship are in two department: Deck Department, Engine Department and Service Department.C、The Deck Department and the Engin

第1题：

第2题：

甲板部由大副负责。（）

• A、The captain is the head of a ship.
• B、The master is the head of a ship.
• C、The deck department is under the command of the chief officer.
• D、The pilot is the head of a ship.

正确答案:C

第3题：

engine department（）

• A、甲板部
• B、轮机部
• C、事务部
• D、策划部

正确答案:B

第4题：

（）is the officer responsible for the overall maintenance of deck department.

• A、Bosun
• B、Chief officer
• C、Third officer
• D、Second officer

正确答案:B

第5题：

大副负责整个甲板部的维修保养工作。（）

• A、The chief officer is responsible for the overall maintenance of the deck department.
• B、The second officer is responsible for the overall cleaning of the deck department.
• C、The third officer is responsible for the overall maintenance of the deck department.
• D、The chief officer is responsible for the overall cleaning of the deck department.

正确答案:A

第6题：

甲板部有九个人。（）

• A、There are nine people in the deck department.
• B、The department has nine people
• C、There are nine people in the deck de
• D、The deck has nine people.

正确答案:C

第7题：

Who is the head of the deck department?（）

• A、Captain.
• B、Bosun.
• C、Chief officer.
• D、Chief engineer.

正确答案:C

第8题：

You have an Exchange Server 2010 organization.  You need to recommend a mailbox storage management solution for your organization to meet thefollowing requirements： .Apply quota limits for users by department.Automatically apply quota limits for new users What should you recommend？（）

• A、A storage group for each department.
• B、A mailbox database for each department.
• C、An organizational unit for each department.
• D、A managed folder mailbox policy for each department.

正确答案:B

第9题：

第10题：

第11题：

第12题：

第13题：

The chief officer is responsible （）the overall maintenance of deck department.

• A、for
• B、to
• C、with
• D、of

正确答案:A

第14题：

Which department do you work in on board?（）

• A、Deck department.
• B、Engine department.
• C、Service department.
• D、Sorry.

正确答案:A

第15题：

在执行语句SELECT department_id FROM employees，departments WHERE employees.department_id= departments.department_id；时报错，原因是（）。

• A、没有给表employees和表departments加别名
• B、没有给列department_id加别名
• C、不能用employees.department_id=departments.department_id作为条件
• D、SELECT后面的department_id没有指定是哪个表

正确答案:D

第16题：

（）is in charge of the common tools of the deck department.

• A、The chief officer
• B、The duty sailor
• C、The bosun
• D、Captain

正确答案:C

第17题：

The varnish is used to paint the woodwork and deck （）(扶手).

• A、cargo
• B、rail
• C、paint
• D、department

正确答案:B

第18题：

The station lists are posted （）on board a ship.

• A、in the engine room
• B、on the gangway
• C、in public places
• D、on the deck

正确答案:C

第19题：

Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）

• A、SELECT last_name, department_name FROM employees NATURAL JOIN departments;
• B、SELECT last_name, department_name FROM employees JOIN departments ;
• C、SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
• D、SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
• E、SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
• F、SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);

正确答案:F

第20题：

第21题：

第22题：

第23题：