ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-067

047-067

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-18 10:14:10 0 删除 编辑
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
(order_id,order_date,order_mode,order_total)
VALUES (1,'10mar2007','online',1000);
Answer: CD
Respectively:分别
非空的字段一定要插入数据
SQL> insert into (select a from test) values(3);

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718847/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-066
下一篇: 047-068
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    215582