ITPub博客

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

047-096

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-18 14:45:36 0 删除 编辑
96. View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS
tables.ORDER_ID is the primary key in the ORDERS table. It is also the foreign
key in the ORDER_ITEMS table where in it is created with the ON DELETE CASCADE
option. Which DELETE statement would execute successfully?
A. DELETE order_id FROM orders WHERE order_total < 1000;
B. DELETE orders WHERE order_total < 1000;
C. DELETE FROM orders WHERE (SELECT order_id FROM order_items);
D.DELETE orders o, order_items I WHERE o.order_id = i.order_id;
Answer: B

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214037