热门：

可学答题网 > 问答 > 1Z0-007题库

目录：标题| 题干| 答案| 搜索| 相关

问题

The CUSTOMERS table has these columns

The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) Which statement finds the rows in the CUSTOMERS table that do not have a postal code? （）

A SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;
B SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________';
C SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL;
D SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;
E SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL

参考答案

参考解析：

分类：1Z0-007题库

1、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 salar...

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

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

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

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

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

编辑推荐

也称真阴性率的指标是..

医生的权利是（）..

对于公司治理基本特征理解错误的有（）。..

气化炉在运行过程所装燃烧室高温热偶全无指示，这时可通过哪.....

银行在为境内机构汇出境外直接投资资金时，可以使用的币种为.....

荷载折减系数..