163.View the Exhibit and examine the description for the CUSTOMERS table.
来源:互联网 发布:投诉淘宝卖家有补偿吗 编辑:程序博客网 时间:2024/05/17 21:57
163.View the Exhibit and examine the description for the CUSTOMERS table.
You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, where
CUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Which SQL statement will accomplish the
SET cust_credit_limit = NULL
WHERE CUST_INCOME_LEVEL = NULL;
B.UPDATE customers
SET cust_credit_limit = NULL
WHERE cust_income_level IS NULL;
C.UPDATE customers
SET cust_credit_limit = TO_NUMBER(NULL)
WHERE cust_income_level = TO_NUMBER(NULL);
D.UPDATE customers
SET cust_credit_limit = TO_NUMBER(' ',9999)
WHERE cust_income_level IS NULL;
答案:B
解析:null不能呢个通过=来判断,排除A,C,D的to_number语法不正确
You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, where
CUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Which SQL statement will accomplish the
task?
SET cust_credit_limit = NULL
WHERE CUST_INCOME_LEVEL = NULL;
B.UPDATE customers
SET cust_credit_limit = NULL
WHERE cust_income_level IS NULL;
C.UPDATE customers
SET cust_credit_limit = TO_NUMBER(NULL)
WHERE cust_income_level = TO_NUMBER(NULL);
D.UPDATE customers
SET cust_credit_limit = TO_NUMBER(' ',9999)
WHERE cust_income_level IS NULL;
答案:B
解析:null不能呢个通过=来判断,排除A,C,D的to_number语法不正确
0 0
- 163.View the Exhibit and examine the description for the CUSTOMERS table.
- 165.View the Exhibit and examine the description for the CUSTOMERS table.
- 169.View the Exhibit and examine the description for the PRODUCTS and SALES table.
- 79.View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CU
- 93.View the Exhibit and examine the structure of the CUSTOMERS table. Using the CUSTOMERS table, y o
- 8.View the Exhibit and examine the structure of the CUSTOMERS table.
- 15.View the Exhibit and examine the data in the CUSTOMERS table.
- 54.View the Exhibit and examine the structure of the CUSTOMERS table.
- 65.View the Exhibit and examine the structure of the CUSTOMERS table.
- 110.View the Exhibit and examine the structure of the CUSTOMERS table.
- 111.View the Exhibit and examine the structure of the CUSTOMERS table.
- 115.View the Exhibit and examine the structure of the CUSTOMERS table.
- 145.View the Exhibit and examine the structure of the CUSTOMERS table.
- 159.View the Exhibit and examine the structure of the CUSTOMERS table.
- 60.View the Exhibit and examine the structure of CUSTOMERS table.
- 161.View the exhibit and examine the description for the SALES and CHANNELS tables.
- 40.View the Exhibit to examine the description for the SALES and PRODUCTS tables.
- 1.View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.
- iOS-网络-同步请求、异步请求、GET请求、POST请求
- GEOS
- SAP中段的含义
- 提取特征的方法及不同场景的处理(目标跟踪)
- python函数 callable(object)
- 163.View the Exhibit and examine the description for the CUSTOMERS table.
- Html position(static | absolute | fixed | relative)定位
- Android View 如何测量
- 为什么要用getBaseContext()方法代替this
- <Head First Java>集合与泛型
- redis扫盲
- BZOJ 1812: [Ioi2005]riv
- 百度cookie使用分析
- Android studio用的几个插件