可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

The EMPLOYEE tables has these columns


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
参考答案
参考解析:
分类:1Z0-007题库
相关推荐

1、The EMPLOYEE tables has these columns

The EMPLOYEE tables has these columns:You want to display the name and annual salary multiplied by the commission_pct for all employees. For re...

2、The CUSTOMERS table has these columns

The CUSTOMERS table has these columns:CUSTOMER_ID NUMBER(4) NOT NULLCUSTOMER_NAME VARCHAR2(100) NOT NULLSTREET_ADDRESS VARCHAR2(150)CITY_ADDRESS VARCHAR...

3、The ORDERS table has these columns:

The ORDERS table has these columns:The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Whic...

4、The EMP table has these columns: Man

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...

5、The EMPLOYEES table has these columns:

The EMPLOYEES table has these columns:LAST_NAME VARCHAR2(35) SALARYNUMBER(8,2) HIRE_DATE DATEManagement wants to add a default value to the SALARY...

6、The CUSTOMERS table has these columns

The CUSTOMERS table has these columns:Which statement finds the rows in the CUSTOMERS table that do not have a postal code?()A SELECT custome...