Where is the Loan Department, please?（）AWho are you?BThis way, pleaseCI don't want to say anythingDWhat can I do for you?

题目

Where is the Loan Department, please?（）

AWho are you?

BThis way, please

CI don't want to say anything

DWhat can I do for you?

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

A: Excuse me, where is the nearest bank, please? B:().

A、It's not sure

B、That's all right

C、It's next to the newsagent

参考答案：C

第2题：

— Repair department.May I help you? — () .

A.Yes.I'd like to know if my CD player has been repaired yet.

B.I asked for the repair department.

C.Just a moment, please.The manager will be in soon.

正确答案：A
解析：服务行业人员接听电话时，习惯上首先报出自己的机构名称。挂电话者会直接说出自己挂电话的目的。选项A符合语言情境。

第3题：

– Pardon me. Could you please tell me where the department store is? –()

(A)All right. Thank you anyway.

(B) It’s a pleasure.

(D) Don’t bother!

正确答案：C
解答参考：C。本题问题为请问，百货商店该怎么走?。选项A好的，谢谢你和选项B很高兴答非所问，选项D不要烦我为非礼貌用语。

第4题：

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));

参考答案：C, D, E

第5题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBERSALARY NUMBERWhat is the correct syntax for an inline view? （）

A. SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;

B. SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))

C. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);

D. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);

参考答案：A

第6题：

Can I have the bill please?().

A、How much is it, Sir?

B、Where is it, Sir?

C、Sure, here you are, Sir.

D、OK, please look at it, Sir.

参考答案：C

第7题：

The only thing _____ really bothers students is whether they will have access to the resources room of the department.

A: that

B: what

C: which

D: where

正确答案: C

第8题：

在执行语句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

第9题：

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）

A. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);

B. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;

C. CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;

D. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);

E. CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;

参考答案：C

第10题：

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));

参考答案：C, D, E

Where is the Loan Department, please?（）

题目

相似问题和答案

更多相关问题

相关内容