数据库benet中有个员工表employees，该表中有职务列，可以实现检查哪些员工的信息中没有填写职务一栏，应该使用子句（）A、Select*from employees where职务＝NULLB、Select*from employees where职务=’NULL’C、Select*from employees where职务ISNULLD、Select*from employees where职务IS‘NULL’

题目

数据库benet中有个员工表employees，该表中有职务列，可以实现检查哪些员工的信息中没有填写职务一栏，应该使用子句（）

A、Select*from employees where职务＝NULL
B、Select*from employees where职务=’NULL’
C、Select*from employees where职务ISNULL
D、Select*from employees where职务IS‘NULL’

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

相似问题和答案

第1题：

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

第2题：

下列哪个语句查出雇员表（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

第3题：

有个员工表employees,该表中有职务列。你想检查哪些员工的信息中没有填写职务一栏,应该使用()。

A.Select*from employees where职务＝NULL

B.Select*from employees where职务=‘NULL’

C.Select*from employees where职务ISNULL

D.Select*from employees where职务IS‘NULL’

参考答案：C

第4题：

学生选课信息表：sc（sno，cno，grade），主键为（sno，cno），从学生选课信息表中找出无成绩的元组的SQL语句是（）。

A、SELECT * FROM sc WHERE grade=NULL
B、SELECT * FROM sc WHERE grade IS “ ”
C、SELECT * FROM sc WHERE grade=‘ ’
D、SELECT * FROM sc WHERE grade IS NULL

正确答案:D

第5题：

下面哪条语句可以取出薪水最高的前三个人：（）

A、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ）；
B、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY ） WHERE ROWNUM<=3；
C、SELECT * FROM （SELECT * FROM EMPLOYEES ORDER BY SALARY DESC） WHERE ROWNUM<=3；
D、SELECT * FROM EMPLOYEES WHERE ROWNUM<=3 ORDER BY SALARY DESC；

正确答案:C

第6题：

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

第7题：

有个员工表employees，该表中有职务列。你想检查哪些员工的信息中没有填写职务一栏，应该使用（）。

A、Select*from employees where职务＝NULL
B、Select*from employees where职务=‘NULL’
C、Select*from employees where职务ISNULL
D、Select*from employees where职务IS‘NULL’

正确答案:C

第8题：

下列哪个语句查出雇员表(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

第9题：

查询student表中的所有非空email信息，以下语句正确的是（）。

A、Select email from student where email !=null
B、Select email from student where email not is null
C、Select email from student where email <> null
D、Select email from student where email is not null

正确答案:D

第10题：

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 WHERE department_id IN (10,20);
E、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;

正确答案:C

题目

相似问题和答案

更多相关问题

相关内容