【OCP-12c】CUUG 071题库考试原题及答案解析(14)
2024-08-25 22:15:15
14、(6-13) choose the best answer:
View the Exhibit and examine the structure of the ORDERS table.
Which UPDATE statement is valid?
A) UPDATE orders
SET order_date = '12-mar-2007'
AND order_total = TO_NUMBER(NULL)
WHERE order_id = 2455;
B) UPDATE orders
SET order_date = '12-mar-2007',
order_total = NULL
WHERE order_id = 2455;
C) UPDATE orders
SET order_date = TO DATE('12-mar-2007','dd-mon-yyyy'),
SET order_total = TO NUMBER(NULL)
WHERE order_id = 2455;
D) UPDATE orders
SET order_date = '12-mar-2007',
order_total IS NULL
WHERE order_id = 2455;
Answer:D
(解析:注意语法)
最新文章
- django xadmin 插件(2) 列表视图新增一功能列
- Redis提供的持久化机制(RDB和AOF)
- ZooKeeper常见问题(转)
- YII2.0上传文件
- 生产WCF客户端类文件的命令格式
- 线程以及数据对象的wait()和notifyAll()方法
- 【转并修改】VS2013 MVC Web项目使用内置的IISExpress支持局域网内部机器(手机、PC)访问、调试
- This application failed to start because it could not find or load the Qt platform plugin ";windows";
- C++中socket编程
- openStack juno for ubuntu12-04
- SilkTest高级进阶系列7-用PostMessage模拟鼠标
- C++ 带有指针成员的类处理方式
- python3全栈开发-什么是粘包、粘包现象、如何解决粘包
- 信息论随笔3: 交叉熵与TF-IDF模型
- CF1155F Delivery Oligopoly
- solrj管理索引库
- JVM配置参数详解
- C语言: 从 CodeBlocks 到 Microsoft Visual Studio 2017
- CF876 D 树状数组
- LINUX设备驱动模型之class