OCP-1Z0-新051-61题版本-30
来源:互联网 发布:畅享6s只有2g网络 编辑:程序博客网 时间:2024/05/28 09:32
QUESTION NO: 30
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 task?
A.UPDATE customers 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;
Answer: B
答案解析:
参考:163:http://blog.csdn.net/rlhua/article/details/12886715
Explanation:
- OCP-1Z0-新051-61题版本-30
- OCP-1Z0-新051-61题版本-61
- OCP-1Z0-新051-61题版本-1
- OCP-1Z0-新051-61题版本-2
- OCP-1Z0-新051-61题版本-3
- OCP-1Z0-新051-61题版本-4
- OCP-1Z0-新051-61题版本-5
- OCP-1Z0-新051-61题版本-6
- OCP-1Z0-新051-61题版本-7
- OCP-1Z0-新051-61题版本-8
- OCP-1Z0-新051-61题版本-9
- OCP-1Z0-新051-61题版本-10
- OCP-1Z0-新051-61题版本-11
- OCP-1Z0-新051-61题版本-12
- OCP-1Z0-新051-61题版本-13
- OCP-1Z0-新051-61题版本-14
- OCP-1Z0-新051-61题版本-15
- OCP-1Z0-新051-61题版本-16
- 【leetcode】将整数取反,-321返回-123(Reverse Integer)
- OCP-1Z0-新051-61题版本-29
- map、multimaps函数
- 常量指针与指针常量的区别(转帖)
- 时域和频域的关系及matlab演示
- OCP-1Z0-新051-61题版本-30
- 原子移动云服务开发者春季联盟启动了
- OCP-1Z0-新051-61题版本-31
- 世界名著100部简介
- PCB设计的一般原则
- OCP-1Z0-新051-61题版本-32
- 锁相环的组成和工作原理
- 聊聊主流框架,Less/Sass/Compass/Bootstrap/H5bp
- 如何在iphone/ipad/itouch上设置新浪VIP邮箱