计算机程序设计

Select雇员_ID FROMemployee WHERE薪水>1250命令的功能是（）。A、查询薪水大于1250的记录B、查询1250号记录后的记录C、检索所有的雇员_IDD、从[employee]关系中检索薪水大于1250的雇员_ID

题目

Select雇员_ID FROMemployee WHERE薪水>1250命令的功能是（）。

  • A、查询薪水大于1250的记录
  • B、查询1250号记录后的记录
  • C、检索所有的雇员_ID
  • D、从[employee]关系中检索薪水大于1250的雇员_ID
如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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

第2题：

The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(4)LAST_NAME VARCHAR2 (25)JOB_ID VARCHAR2(10)You want to search for strings that contain ‘SA_‘ in the JOB_ID column. Which SQL statement do you use?（）

A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA\_%‘ESCAPE‘\‘;

B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_‘;

C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_‘ESCAPE‘\‘;

D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id ‘%SA_‘;


参考答案：A

第3题：

下列哪个语句查出雇员表(employees)里的雇员名字(ename)是‘SMITH’的信息,并且给雇员名字(ename)列定义一个别名Name()。

A.select employeesno，ename Name，job from employees where ename=‘SMITH’

B.select employeesno，ename ‘Name’，job from employees where ename=SMITH

C.select employeesno，ename “Name”，job from employees where ename=‘SMITH’

D.select employeesno，ename ‘Name’，job frome mployees wheree name=‘SMITH’


参考答案：A

第4题：

下列哪个语句查出雇员表（employees）里的雇员名字（ename）是‘SMITH’的信息，并且给雇员名字（ename）列定义一个别名Name（）。

  • A、select employeesno，ename Name，job from employees where ename=‘SMITH’
  • B、select employeesno，ename ‘Name’，job from employees where ename=SMITH
  • C、select employeesno，ename “Name”，job from employees where ename=‘SMITH’
  • D、select employeesno，ename ‘Name’，job frome mployees wheree name=‘SMITH’

正确答案:A

第5题：

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


参考答案：C, D, E

第6题：

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

第7题：

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

第8题：

下面语句中，表示过虑条件是vend_id=1002或vend_id=1003的是( )

A.select * from products where vend_id=1002 or vend_id=1003

B.select * from products where vend_id in (1002,1003);

C.select * from products where vend_id not in (1004,1005);

D.select * from products where vend_id=1002 and vend_id=1003


正确答案：B,A 

第9题：

以下用法中正确的是（）

ARS = conn.Execute（“SELECT *FORM product”）

BSet RS = conn.Execute （“SELECT *FORM product”）

CConn.Execute （“DELETE *FORM product WHERE ID=132”）

DConn.Ececute “DELETE *FORM product WHERE ID=132”


B
略

第10题：

V5.x系统中，查询动环网管数据库中端局编号为102的端局名的SQL语句是（）

  • A、selct*from office where officeid=102
  • B、select*form office where officeid=102
  • C、select*form office where office_id=102
  • D、select*from office where office_id=102

正确答案:D

更多相关问题
相关内容