题目内容

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

查看答案
更多问题

毛泽东指出:战略上()敌人,战术上重视敌人。

A. 藐视
B. 重视
C. 防备
D. 注重

()是指通过公用电网供给客户端的交流电能的品质。

A. 电压质量
B. 电能质量
C. 频率质量

()用于培养丝状菌时,则在培养基表面上往形成固体菌膜。

一个人的忠诚感和献身精神是天生的,这是无法通过员工培训来得到的。

A. 正确
B. 错误

答案查题题库