搜题

【单选题】

The selection of a lubricating oil depends to a great extent on the operating conditions,（）.

A、the type of coolant

B、the design of the engine

C、the type of fuel to be burned

D、B and C

查看正确答案

更多“The selection of a lubricating oil depends to a great extent on the operating conditions,（）.”相关的问题

第1题

[多选题] In which four clauses can a subquery be used?（）

A、in the INTO clause of an INSERT statement B、in the FROM clause of a SELECT statement C、in the GROUP BY clause of a SELECT statement D、in the WHERE clause of a SELECT statement E、in the SET clause of an UPDATE statement F、in the VALUES clause of an INSERT statement

点击查看答案

第2题

[多选题] In which four clauses can a subquery be used? （）

点击查看答案

第3题

[] Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）

A、A.SELECT UNIQUE dept FROM staff B、B.SELECT DISTINCT dept FROM staff C、C.SELECT (dept) UNIQUE FROM staff D、D.SELECT (dept) DISTINCT FROM staff

点击查看答案

第4题

[单选题] What is the first step that you would use Cisco Product Advisor for when selecting a router for an Edge solution?（）

A、determine types of protocols to be supported B、determine the environment in which the router will be used C、select the number of WAN ports required D、select the number of LAN ports required

点击查看答案

第5题

[] Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（） Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）

A、A.No change is required to achieve the desired results. B、B.SELECT ename, sal, 12*(sal+100) FROM emp; C、C.SELECT ename, sal, (12*sal)+100 FROM emp; D、D.SELECT ename, sal+100,*12 FROM emp;

点击查看答案

第6题

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

点击查看答案

第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 description of the MARKS table: SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: What is the result of the SELECT statement?（）

A、The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject. B、The statement returns an error at the SELECT clause. C、The statement returns an error at the WHERE clause. D、The statement returns an error at the ORDER BY clause.

点击查看答案

第9题

[单选题] Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）

A、No change is required to achieve the desired results. B、SELECT ename, sal, 12*(sal+100) FROM emp; C、SELECT ename, sal, (12*sal)+100 FROM emp; D、SELECT ename, sal+100,*12 FROM emp;

点击查看答案

第10题

[单选题] Evaluate this SQL statement: SELECT ename, sal, 12* sal+100 FROM emp; The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?（）

A、No change is required to achieve the desired results. B、SELECT ename, sal, 12* (sal+100) FROM emp; C、SELECT ename, sal, (12* sal)+100 FROM emp; D、SELECT ename, sal +100,*12 FROM emp;

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

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