网友您好，请在下方输入框内输入要搜索的题目：

搜题

题目内容（请给出正确答案）

提问人：网友eelb123 发布时间：2022-01-07

[主观题]

The EMP table contains these columns:LAST NAME VARCHAR2（25)SALARY NUMBER（6,2)DEPARTMENT_ID

The EMP table contains these columns:LAST NAME VARCHAR2(25)SALARY NUMBER(6,2)DEPARTMENT_ID NUMBER(6)You need to display the employees who have not been assigned to any department.You write the SELECT statement:SELECT LAST_NAME, SALARY, DEPARTMENT_IDFROM EMPWHERE DEPARMENT_ID = NULL;What is true about this SQL statement？（）

A. The SQL statement displays the desired results.

B. The column in the WHERE clause should be changed to display the desired results.

C. The operator in the WHERE clause should be changed to display the desired results.

D. The WHERE clause should be changed to use an outer join to display the desired results.

简答题官方参考答案（由简答题聘请的专业题库老师提供的解答）

查看官方参考答案

更多“The EMP table contains these columns:LAST NAME VARCHAR2（25)SALARY NUMBER（6,2)DEPARTMENT_ID”相关的问题

第1题

The EMP table contains these columns:LAST NAME VARCHAR2（25)SALARY NUMBER（6,2)DEPARTMENT_ID

A. The SQL statement displays the desired results.

B. The column in the WHERE clause should be changed to display the desired results.

C. The operator in the WHERE clause should be changed to display the desired results.

D. The WHERE clause should be changed to use an outer join to display the desired results.

点击查看答案

第2题

Management has asked you to calculate the value 12*salary* commission_pct for all the empl

oyees in the EMP table. The EMP table contains these columns:LAST NAME VARCNAR2(35) NOT NULLSALARY NUMBER(9,2) NOT NULLCOMMISION_PCT NUMBER(4,2)Which statement ensures that a value is displayed in the calculated columns for all employees？（）

A. SELECT last_name, 12*salary* commission_pct FROM emp;

B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;

C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;

D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

点击查看答案

第3题

The EMP table contains these columns:LAST_NAME VARCHAR2 （25)SALARY NUMBER （6,2)DEPARTMENT_

The EMP table contains these columns:LAST_NAME VARCHAR2 (25)SALARY NUMBER (6,2)DEPARTMENT_ID NUMBER (6)You need to display the employees who have not been assigned to any department. You write the SELECT statement:SELECT LAST_NAME, SALARY, DEPARTMENT_IDFROM EMPWHERE DEPARTMENT_ID = NULL;What is true about this SQL statement ？（）

A.The SQL statement displays the desired results.

B.The column in the WHERE clause should be changed to display the desired results.

C.The operator in the WHERE clause should be changed to display the desired results.

D.The WHERE clause should be changed to use an outer join to display the desired results.

点击查看答案

第4题

You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement displays the required results？（）

A. SELECT last_name FROM EMP WHERE last_ name LIKE ‘_A%‘;

B. SELECT last_name FROM EMP WHERE last name =‘*A%‘

C. SELECT last_name FROM EMP WHERE last name =‘_A%‘;

D. SELECT last_name FROM EMP WHERE last name LIKE ‘*A%‘

点击查看答案

第5题

The EMP table has these columns:ENAME VARCHAR2（35)SALARY NUMBER（8,2)HIRE_DATE DATEManageme

The EMP table has these columns:ENAME VARCHAR2(35)SALARY NUMBER(8,2)HIRE_DATE DATEManagement wants a list of names of employees who have been with the company for more than five years.Which SQL statement displays the required results？（）

A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

C. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

D. SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

点击查看答案

第6题

_________________ contains words, numbers or signs, or a combination of these, displayed in columns or boxes.

A．Pie chart

B．Bar chart

C．Line graph

D．Table

点击查看答案

第7题

Which SQL statement accepts user input for the columns to be displayed, the table name, and the WHERE condition？（）

A.SELECT &1, "&2" FROM &3 WHERE last_name = ‘&4‘;

B.SELECT &1, ‘&2‘ FROM &3 WHERE ‘&last_name = ‘&4‘‘;

C.SELECT &1, &2 FROM &3 WHERE last_name = ‘&4‘;

D.SELECT &1, ‘&2‘ FROM EMP WHERE last_name = ‘&4‘;

点击查看答案

第8题

Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition？（）

A. SELECT &1, "&2" FROM &3 WHERE last_name = ‘&8‘;

B. SELECT &1, ‘&2‘ FROM &3 WHERE ‘& last_name = ‘&8‘;

C. SELECT &1, &2 FROM &3 WHERE last_name = ‘&8‘;

D. SELECT &1, ‘&2‘ FROM EMP WHERE last_name = ‘&8‘;

点击查看答案

第9题

The EMP table has these columns:Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results？（）

A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE > 5;

B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE > 5;

C. SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)/365 > 5;

D. SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)* 365 > 5;

点击查看答案

第10题

以下能够删除一列的是（) A.alter table emp remove addcolumn B.alter table emp drop

以下能够删除一列的是()

A.alter table emp remove addcolumn

B.alter table emp drop column addcolumn

C.alter table emp delete column addcolumn

D.alter table emp delete addcolumn

点击查看答案

账号：尚未登录

登录没有账号？去注册

搜题记录

联系客服

购买搜题卡

考试指南全部 >

自考本科在哪里考报名流程是怎样 2024年每年自考本科的报名时间考哪些内容 2024年女生最实用的自考专业含金量高的推荐 2024年成人高考和成人自考哪个更好有什么区别 2024年自考本科网上报名条件考试科目有什么 2024成人高中学历怎么提升学历考哪些内容 2024年自考成人本科考哪些科目合格标准是多少 2024年自考什么时候报名考哪些内容 2024年本科自考报考时间考哪些内容 2024年自考本科在哪里报名报考条件有哪些

购买搜题卡查看答案

购买前请仔细阅读《购买须知》

请选择支付方式

微信支付

支付宝支付

点击支付即表示你同意并接受《服务协议》和《购买须知》

立即支付已付款，但不能查看答案，请点这里登录即可>>

搜题卡使用说明

1. 搜题次数扣减规则：

功能	扣减规则
功能	基础费（查看答案）	加收费（AI功能）
文字搜题、查看答案	1/每题	0/每次
语音搜题、查看答案	1/每题	2/每次
单题拍照识别、查看答案	1/每题	2/每次
整页拍照识别、查看答案	1/每题	5/每次