搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

Our department（）courses in several foreign languages.

A、accepts

B、considers

C、offers

D、takes

查看正确答案
更多“Our department（）courses in several foreign languages.”相关的问题
第1题
[单选题] Our Accounts Receivable Department has written to you three times;（）,we have had no response to our letters.

A、consequently  B、moreover  C、thus  D、however  

点击查看答案
第2题
[单选题] 船上的船员属于三个部门：甲板部、轮机部和事务部。（）

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 Engine Department are the two departments.  D、Seamen on board the ship are in three departments: the Deck Department, the Engine Department and the Service Department.  

点击查看答案
第3题
[] 在执行语句SELECT department_id FROM employees，departments WHERE employees.department_id= departments.department_id；时报错，原因是（）。

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

点击查看答案
第4题
[] 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);  

点击查看答案
第5题
[单选题] 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);  

点击查看答案
第6题
[单选题] 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);  

点击查看答案
第7题
[单选题] Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement?（）

A、SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);  B、SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;  C、SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;  D、SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);  

点击查看答案
第8题
[] Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement? （） Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30)

A、A. SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);  B、B. SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;  C、C. SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;  D、D. SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);  

点击查看答案
第9题
[单选题] 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 to create an equi-join?（）

A、SELECT last_name, department_name, location_id FROM employees , department ;  B、SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;  C、SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id = manager_id;  D、SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

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