网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
The salary of an engineer is much higher__.
A.than a teacher
B.than that of a teacher
C.in comparison with a teacher's
D.than of a teacher's
B.than that of a teacher
C.in comparison with a teacher's
D.than of a teacher's
参考答案
参考解析
解析：that替代的是不可数名词salary。
更多 “The salary of an engineer is much higher__.A.than a teacher B.than that of a teacher C.in comparison with a teacher's D.than of a teacher's” 相关考题
考题
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? ()
A. ORDER BY SALARY 5000B. GROUP BY SALARY 5000C. HAVING SALARY 5000D. WHERE SALARY 5000
考题
Examine the data in the EMPLOYEES table:Which three subqueries work? ()
A. SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C. SELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D. SELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E. SELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F. SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
考题
Evaluate the SQL statement:What is the result of the statement?()
A. The statement produces an error at line 1.B. The statement produces an error at line 3.C. The statement produces an error at line 6.D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
考题
Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000...Which three subqueries work? ()
A. SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C. SELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D. SELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E. SELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F. SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
考题
Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? ()
A.SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department_id);B.SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);C.SELECT distinct department_id FROM employees WHERE salary ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);D.SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);E.SELECT last_name FROM employees WHERE salary ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);F.SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));
考题
SQL中，SALARYIN(1000，2000)的语义是______。A．SALARY≤2000 AND SALARY≥1000B．SALARY＜2000 AND SALARY＞1000C．SALARY=1000 AND SALARY=2000D．SALARY=1000 OR SALARY=2000
考题
Which is not one of the things researched by a bank? __________A.How much money the borrower owns
B.What salary the borrower makes
C.What kind of job the borrower has
D.What kind of house the borrower lives in
考题
His salary as a driver is much higher than（）Aa porterBis a porterCas a porterDthat of a porter
考题
SELECT语句中使用（）子句来显示工资超过5000的员工。A、ORDER BY SALARY5000B、GROUP BY SALARY5000C、HAVING SALARY5000D、WHERE SALARY5000
考题
His salary as a driver is much higher than（）A、a porterB、is a porterC、as a porterD、that of a porter
考题
A Network Engineer is reporting that one of the AIX hosts is generating too much ICMP traffic, which is slowing the network. Which of the following options is the most probable cause?（）A、A large FTP job is in process. B、A network interface was misconfigured. C、The ping command is being used excessively. D、A bad network interface card and/or network cable is in use.
考题
Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? （）A、SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C、SELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D、SELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E、SELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F、SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
考题
单选题Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_ NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR2(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only if the minimum salary is less than 5000 and maximum salary is more than 15000?（）A
SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000;B
SELECT dept_id, MIN(salary), MAX(salary) FROM employees WHERE MIN(salary) 5000 AND MAX(salary) 15000 GROUP BY dept_id;C
SELECT dept_id, MIN(salary), MAX(salary) FROM employees HAVING MIN(salary) 5000 AND MAX(salary) 15000;D
SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id HAVING MIN(salary) 5000 AND MAX(salary) 15000;E
SELECT dept_id, MIN(salary), MAX(salary) FROM employees GROUP BY dept_id, salary HAVING MIN(salary) 5000 AND MAX(salary) 15000;
考题
多选题Examine the data in the EMPLOYEES table: Which three subqueries work? （）ASELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);CSELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);DSELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);ESELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);FSELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
考题
单选题His salary as a driver is much higher than（）.A
a porterB
is a porterC
that of a porterD
as a porter
考题
单选题No sooner （） than they started to repair the sludge pump.A
the second engineer had got into the engine roomB
the second engineer got into the engine roomC
has the second engineer got into the engine roomD
did the second engineer get into the engine room
考题
单选题Tony’s salary as a plumber is much higher than _____.A
a teacherB
a teacher hasC
that of a teacher doesD
that of a teacher
考题
单选题Tony’s salary as a plumber is much higher than ______.A
a teacher B
a teacher hasC
that of a teacher doesD
that of a teacher
考题
单选题Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）A
SELECT ename, salary*12 ‘Annual Salary’ FROM employees;B
SELECT ename, salary*12 “Annual Salary” FROM employees;C
SELECT ename, salary*12 AS Annual Salary FROM employees;D
SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees
考题
单选题Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）A
ORDER BY SALARY 5000B
GROUP BY SALARY 5000C
HAVING SALARY 5000D
WHERE SALARY 5000
考题
单选题删除视图salary的命令是（ ）。A
DROP VIEW salaryB
DROP salary VIEWC
DELECT salaryD
DELECT salary VIEW
考题
单选题According to the passage, before taking a job, a person should _____.A
demonstrate his capabilityB
give his boss a good impressionC
ask for as much money as he canD
ask for the salary he hopes to get
热门标签
最新试卷