Which department do you work in on board?（）

A、Deck department.

B、Engine department.

C、Service department.

D、Sorry.

查看正确答案

更多“Which department do you work in on board?（）”相关的问题

第1题

[多选题] Which result or results do these actions produce？（）

A、Users in both departments can access their files from the network. B、Users in the accounting department can view the legal department’s documents. C、Users in the legal department cannot view the accounting department’s documents. D、Company managers can access and modify both departments’ files.

点击查看答案

第2题

[] Examine the data in the EMPLOYEES and DEPARTMENTS tables. EMPLOYEES LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 Kochhar 5000 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Sales 20 Marketing 30 Accounts 40 Administration You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（） Examine the data in the EMPLOYEES and DEPARTMENTS tables. EMPLOYEES LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 Kochhar 5000 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Sales 20 Marketing 30 Accounts 40 Administration You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）

A、A. SELECT last_name, department_name FROM employees , departments(+); B、B. SELECT last_name, department_name FROM employees JOIN departments(+); C、C. SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d D、D. SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id); E、E. SELECT last_name, department_name FROM employees(+) , departments ON (e. department _ id = d. department _id); F、F. SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e. department _ id = d. department _id);

点击查看答案

第3题

[] Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?（） Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?（）

A、A.to find the tax percentage for each of the employees B、B.to list the name, job_id, and manager name for all the employees C、C.to find the name, salary, and the department name of employees who are not working with Smith D、D.to find the number of employees working for the Administrative department and earning less than 4000 E、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题

[单选题] Click the Exhibit button to examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. Two new departments are added to your company as shown: DEPARTMENT_ID DEPARTMENT_NAME MGR_ID LOCATION_ID 9998 Engineering 123 9999 Administrative Boston You need to list the names of employees, the department IDs, the department names, and the cities where the departments are, even if there are no employees in the departments and even if the departments are not yet assigned to a location. You need to join the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables to retrieve this information. Which statement do you execute to retrieve this information?（）

A、SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d RIGHT OUTER JOIN employees e ON d.department_id = e.department_id RIGHT OUTER JOIN locations l ON d.location_id = l.location_id; B、SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d FULL OUTER JOIN employees e ON d.department_id = e.department_id FULL OUTER JOIN locations l ON d.location_id = l.location_id; C、SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d LEFT OUTER JOIN employees e ON d.department_id = e.department_id LEFT OUTER JOIN locations l ON d.location_id = l.location_id; D、SELECT last_name, department_id, department_name, city FROM departments d NATURAL JOIN employees e NATURAL JOIN locations l;

点击查看答案

第6题

[单选题] Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?（）

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.

点击查看答案

第7题

[] Click the Exhibit button to examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. Two new departments are added to your company as shown: DEPARTMENT_ID DEPARTMENT_NAME MGR_ID LOCATION_ID 9998 Engineering 123 9999 Administrative Boston You need to list the names of employees, the department IDs, the department names, and the cities where the departments are, even if there are no employees in the departments and even if the departments are not yet assigned to a location. You need to join the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables to retrieve this information. Which statement do you execute to retrieve this information?（） Click the Exhibit button to examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. Two new departments are added to your company as shown: DEPARTMENT_ID DEPARTMENT_NAME MGR_ID LOCATION_ID 9998 En

A、A.SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d RIGHT OUTER JOIN employees e ON d.department_id = e.department_id RIGHT OUTER JOIN locations l ON d.location_id = l.location_id; B、B.SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d FULL OUTER JOIN employees e ON d.department_id = e.department_id FULL OUTER JOIN locations l ON d.location_id = l.location_id; C、C.SELECT e.last_name, d.department_id, d.department_name, l.city FROM departments d LEFT OUTER JOIN employees e ON d.department_id = e.department_id LEFT OUTER JOIN locations l ON d.location_id = l.location_id; D、D.SELECT last_name, department_id, department_name, city FROM departments d NATURAL JOIN employees e NATURAL JOIN locations l;

点击查看答案

第8题

[] Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use?（） Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEES EMPLOYEE_ID NUMBER DEPARTMENT_ID NUMBER MANAGER_ID NUMBER LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER MANAGER_ID NUMBER DEPARTMENT_NAME VARCHAR2(35) LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use?（）

A、A.SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ; B、B.SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id; C、C.SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d; D、D.SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id );

点击查看答案

第9题

[单选题] 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);

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服