单选题EMPLOYEES中职员编号为90的职员的commission_pct为空值，salary为1000，语句select12*salary*（commission_pct+0.2）comm from EMPLOYEES；comm显示的结果是（）。A12000B0C2400DNULL
单选题
EMPLOYEES中职员编号为90的职员的commission_pct为空值，salary为1000，语句select12*salary*（commission_pct+0.2）comm from EMPLOYEES；comm显示的结果是（）。
A
12000
B
0
C
2400
D
NULL
参考解析
解析：
暂无解析
相关考题：
客户需要计算EMP表中所有职工12*salary* commission_pct的值.EMP表结构如下:LAST NAME VARCNAR2(35)NOT NULL SALARY NUMBER(9,2)NOT NULL COMMISION_PCTNUMBER(4,2)哪个语句可以查询计算EMP表中所有职工行?() A.SELECT last_name，12*salary* commission_pct FROM empB.SELECT last_name，12*salary*（commission_pct，0）FROM empC.SELECT last_name，12*salary*（nvl（commission_pct，0））FROM emp如果oracle第一个参数为空那么显示第二个参数的值，如果第一个参数的值不为空，则显示第一个参数本来的值D.SELECT last_name，12*salary*（decode（commission_pct，0））FROM emp
EMPLOYEES中职员编号为90的职员的commission_pct为空值,salary为1000,语句select12*salary*(commission_pct＋0.2)comm from EMPLOYEES;comm显示的结果是()。 A.12000B.0C.2400D.NULL
显示没有签订任何订单的职员信息（职员号和姓名），正确的SQL语句是A) SELECT职员．职员号，姓名FROM职员JOIN订单ON订单．职员号二职员．职员号GROUP BY职员．职员号HAVING COUNT(*)=0B) SELECT职员．职员号，姓名FROM职员LEFT JOIN订单ON订单．职员号二职员．职员号GROUP BY职员．职员号HAVING COUNT（*）=0C）SELECT职员号，姓名FROM职员WHERE职员号NOT IN(SELECT职员号FROM订单）D) SELECT职员．职员号，姓名FROM职员WHERE职员．职员号＜＞(SELECT订单．职员号FROM订单）
有以下SQL语句：SELECT 订单号，签订日期，金额 FROM 订单，职员WHERE 订单.职员号=职员.职员号 AND 姓名=“李二”与如上语句功能相同的SQL语句是A) SELECT订单号，签订日期，金额FROM订单WHERE EXISTS（SELECT*FROM职员WHERE姓名＝“李二”）B) SELECT订单号，签订日期，金额FROM订单WHEREEXISTS（SELECT*FROM职员WHERE职员号＝订单．职员号AND姓名＝“李二”：C) SELECT订单号，签订日期，金额FROM订单WHERE IN（SELECT职员号FROM职员WHERE姓名＝“李二”）D) SELECT订单号，签订日期，金额FROM订单WHEREIN（SELECT职员号FROM职员WHERE职员号＝订单．职员号AND姓名=“李二”）
The EMPLOYEES table contains these columns:LAST_NAME VARCHAR2 (25)SALARY NUMBER (6,2)COMMISSION_PCT NUMBER (6)You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value. Evaluate the SQL statement:SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEESWHERE COMMISSION_PCT IS NOT NULL;What does the statement provide? （）A. All of the desired resultsB. Two of the desired resultsC. One of the desired resultsD. An error statement
The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.Which SQL statement displays the desired results? （）A. SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;B. SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;C. SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;D. SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
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));
建立一个“职员”表，表中有5个字段：职员号、姓名、性别、年龄、部门。要求职员号属性的值唯一，并且不能为空值。建立该表的SQL语句可以是______。A．CREATE TABLE 职员(职员号 CHAR(6)，姓名CHAR(8)，； 性别CHAR(2)，年龄INT(4)，部门CHAR(12))B．CREATE TABLE职员(职员号CHAR(6)NULL，姓名CHAR(8)，； 性别CHAR(2)，年龄INT(4)，部门CHAR(12))C．CREATE TABLE 职员(职员号CHAR(6)NOT NULL UNIQUE，； 姓名CHAR(8)，性别CHAR(2)，年龄INT(4)，部门CHAR(12))D．CREATE TABLE职员(职员号CHAR(6)UNIQUE，姓名CHAR(8)，： 性别CHAR(2)，年龄INT(4)，部门CHAR(12))
有以下SQL语句： SELECT订单号．签订日期，金额FROM订单，职员 WHERE订单．职员号=职员．职员号AND姓名=”王五” 与如上语句功能相同的SQL语句是（ ）。A. SELECT订单号，签订日期，金额FROM订单 WHERE EXISTS(SELECT*FROM职员WHERE姓名=”王五”)B. SELECT订单号，签订日期，金额FROM订单WHERE EXISTS(SELECT书FROM职员WHERE职员号=订单．职员号AND姓名=”王五”)C. SELECT订单号，签订日期，金额FROM订单 WHERE IN(SELECT职员号FROM职员WHERE姓名=”李二”)D. SELECT订单号，签订日期，金额FROM订单WHERE IN(SELECT职员号FROM职员WHERE职员号=订单．职员号AND姓名=”王五”)
下面哪条语句可以取出薪水最高的前三个人：（）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；
The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）A、All of the desired resultsB、Two of the desired resultsC、One of the desired resultsD、An error statement
单选题The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1.Display the salary multiplied by the commission_pct. 2.Exclude employees with a zero commission_pct. 3.Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide?（）Aall of the desired resultsBtwo of the desired resultsCone of the desired resultsDan error statement
多选题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));
单选题有如下职员数据库表：职员（职员号（C，3），姓名（C，6），性别（C，2），职务（C，10））为职员表的“职员号”字段设置有效性规则“第1位必须是字母E”，正确的SQL语句是（ ）。AALTER TABLE职员ALTER职员号CHECK LEFT(职员号，1)=‘E’BALTER TABLE职员ADD职员号CHECK LEFT(职员号，1)=‘E’CALTER TABLE职员ALTER职员号SET CHECK LEFT(职员号，1)=‘E’DALTER TABLE职员ALTER职员号ADD CHECK LEFT(职员号，1)=‘E’
单选题您在公司的数据库中成功创建了名为SALARY的表。您现在要通过向引用EMPLOYEES表的匹配列的SALARY表添加FOREIGNKEY约束条件来建立EMPLOYEES表与SALARY表之间的父/子关系。尚未向SALARY表添加任何数据。应执行以下哪条语句（）AALTER TABLE salary ADD CONSTRAINT fk_employee_id_01 FOREIGN KEY（employee_id）REFERENCES employees（employee_id）BALTER TABLE salary ADD CONSTRAINT fk_employee_id_ FOREIGN KEY BETWEEN salary（employee_id）AND employees（employee_id）CALTER TABLE salary FOREIGN KEY CONSTRAINT fk_employee_id_REFERENCES employees（employee_id）DALTER TABLE salary ADD CONSTRAINT fk_employee_id_FOREIGN KEY salary（employee_id）=employees（employee_id）
单选题客户需要计算EMP表中所有职工12*salary* commission_pct的值.EMP表结构如下：LAST NAME VARCNAR2（35）NOT NULL SALARY NUMBER（9，2）NOT NULL COMMISION_PCTNUMBER（4，2）哪个语句可以查询计算EMP表中所有职工行？（）ASELECT last_name，12*salary* commission_pct FROM empBSELECT last_name，12*salary*（commission_pct，0）FROM empCSELECT last_name，12*salary*（nvl（commission_pct，0））FROM emp如果oracle第一个参数为空那么显示第二个参数的值，如果第一个参数的值不为空，则显示第一个参数本来的值DSELECT last_name，12*salary*（decode（commission_pct，0））FROM emp
单选题Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）ASELECT ename, salary*12 ‘Annual Salary’ FROM employees;BSELECT ename, salary*12 “Annual Salary” FROM employees;CSELECT ename, salary*12 AS Annual Salary FROM employees;DSELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees
单选题The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1.Display the salary multiplied by the commission_pct. 2.Exclude employees with a zero commission_pct. 3.Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide?（）Aall of the desired resultsBtwo of the desired resultsCone of the desired resultsDan error statement
单选题Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）ASELECT last_name, 12*salary* commission_pct FROM emp;BSELECT last_name, 12*salary* (commission_pct,0) FROM emp;CSELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;DSELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
单选题The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）ASELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;BSELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;CSELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;DSELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
单选题Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees? （）ASELECT last_name, 12*salary* commission_pct FROM emp;BSELECT last_name, 12*salary* (commission_pct,0) FROM emp;CSELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;DSELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;