ocp-047-67

67. View the Exhibit and examine the structure of the ORDERS table. The 
columns ORDER_MODE and ORDER_TOTAL have the default values 'direct' and 0 
respectively.Which two INSERT statements are valid? (Choose two.) 
 
A. INSERT INTO orders 

VALUES (1, '09mar2007','online','',1000); 

B. INSERT INTO orders 
(order_id,order_date,order_mode,customer_id,order_total) 
VALUES(1,TO_DATE(NULL), 'online', 101, NULL); 
C. INSERT INTO 
(SELECT order_id,order_date,customer_id FROM orders) 
VALUES (1,'09mar2007',101); 
D. INSERT INTO orders 

VALUES (1,'09mar2007',DEFAULT, 101, DEFAULT); 
E. INSERT INTO orders 

实验

create table orders (order_id number(12), order_date timestamp(6), order_mode varchar2(8), customer_id number(6), order_total number(8,2) )；ALTER TABLE orders MODIFY (order_id NOT NULL);ALTER TABLE orders MODIFY (order_date NOT NULL);ALTER TABLE orders MODIFY (customer_id NOT NULL);

SQL> alter session set NLS_DATE_LANGUAGE='AMERICAN';会话已更改。SQL> INSERT INTO orders  2  VALUES (1, '09mar2007','online','',1000);VALUES (1, '09mar2007','online','',1000)                                *第 2 行出现错误:ORA-01400: 无法将 NULL 插入 ("A"."ORDERS"."CUSTOMER_ID")SQL> INSERT INTO orders  2  (order_id,order_date,order_mode,customer_id,order_total)  3  VALUES(1,TO_DATE(NULL), 'online', 101, NULL);VALUES(1,TO_DATE(NULL), 'online', 101, NULL)         *第 3 行出现错误:ORA-01400: 无法将 NULL 插入 ("A"."ORDERS"."ORDER_DATE")SQL> INSERT INTO  2  (SELECT order_id,order_date,customer_id FROM orders)  3  VALUES (1,'09mar2007',101);已创建 1 行。

SQL> INSERT INTO orders  2  VALUES (1,'09mar2007',DEFAULT, 101, DEFAULT);已创建 1 行。

SQL> INSERT INTO orders  2  (order_id,order_date,order_mode,order_total)  3  VALUES (1,'10mar2007','online',1000);INSERT INTO orders*第 1 行出现错误:ORA-01400: 无法将 NULL 插入 ("A"."ORDERS"."CUSTOMER_ID")