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

题目内容 (请给出正确答案)
单选题
EMPLOYEES中职员编号为90的职员的commission_pct为空值,salary为1000,语句select12*salary*(commission_pct+0.2)comm from EMPLOYEES;comm显示的结果是()。
A

12000

B

0

C

2400

D

NULL


参考答案

参考解析
解析: 暂无解析
更多 “单选题EMPLOYEES中职员编号为90的职员的commission_pct为空值,salary为1000,语句select12*salary*(commission_pct+0.2)comm from EMPLOYEES;comm显示的结果是()。A 12000B 0C 2400D 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姓名=”王五”)

考题 有如下SQL语句:SELECT订单号,签订日期,金额 FROM 订单,职员:WHERE订单.职员号=职员.职员号AND姓名=”李二”与如上语句功能相同的SQL语句是( )。

考题 假定月工作业绩关系模式为:月工作业绩(职员代码、年月、工作日期),请给出“查询职员代码、职员名、年月、月工资”的SQL语句。

考题 Access版本软件查看职员档案时,出现实时错“94,NULL值无效”其原因是:() A.有职员的帐号为空;B.有职员的编码重复;C.有职员的名称重复;D.有职员的档案为空。

考题 下面哪条语句可以取出薪水最高的前三个人:()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;

考题 在职员档案建立过程中,要求输入唯一值的是()。A、职员编号B、职员姓名C、所属部门D、职员属性

考题 Access版本软件查看职员档案时,出现实时错“94,NULL值无效”其原因是:()A、有职员的帐号为空;B、有职员的编码重复;C、有职员的名称重复;D、有职员的档案为空。

考题 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

考题 单选题在职员档案建立过程中,要求输入唯一值的是()。A 职员编号B 职员姓名C 所属部门D 职员属性

考题 单选题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

考题 多选题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语句是(  )。A ALTER TABLE职员ALTER职员号CHECK LEFT(职员号,1)=‘E’B ALTER TABLE职员ADD职员号CHECK LEFT(职员号,1)=‘E’C ALTER TABLE职员ALTER职员号SET CHECK LEFT(职员号,1)=‘E’D ALTER TABLE职员ALTER职员号ADD CHECK LEFT(职员号,1)=‘E’

考题 单选题您在公司的数据库中成功创建了名为SALARY的表。您现在要通过向引用EMPLOYEES表的匹配列的SALARY表添加FOREIGNKEY约束条件来建立EMPLOYEES表与SALARY表之间的父/子关系。尚未向SALARY表添加任何数据。应执行以下哪条语句()A ALTER TABLE salary ADD CONSTRAINT fk_employee_id_01 FOREIGN KEY(employee_id)REFERENCES employees(employee_id)B ALTER TABLE salary ADD CONSTRAINT fk_employee_id_ FOREIGN KEY BETWEEN salary(employee_id)AND employees(employee_id)C ALTER TABLE salary FOREIGN KEY CONSTRAINT fk_employee_id_REFERENCES employees(employee_id)D ALTER 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表中所有职工行?()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

考题 单选题Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?()A SELECT ename, salary*12 ‘Annual Salary’ FROM employees;B SELECT ename, salary*12 “Annual Salary” FROM employees;C SELECT ename, salary*12 AS Annual Salary FROM employees;D SELECT 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?()A all of the desired resultsB two of the desired resultsC one of the desired resultsD an 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?()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;

考题 单选题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;

考题 单选题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? ()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;