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