大家好，我是考100分的小小码 ，祝大家学习进步，加薪顺利呀。今天说一说2016年7月n2真题答案百度文库_2019年4月的专票认证时限,希望您对编程的造诣更进一步.
choose three
The ORDERS table has a primary key constraint on the ORDER_ID column.
The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column,referencing the primary key of the ORDERS table.
The constraint is defined with on DELETE CASCADE.
There are rows in the ORDERS table with an ORDER_TOTAL less than 1000.
Which three DELETE statements execute successfully?
A) DELETE FROM orders WHERE order_total<1000;
B) DELETE * FROM orders WHERE order_total<1000;
C) DELETE orders WHERE order_total<1000;
D) DELETE FROM orders;
E) DELETE order_id FROM orders WHERE order_total<1000;
Answer：ACD
(解析：这个考的是语法题，属于低智商题目，因为定义外键的时候用了 DELETE CASCADE 选项，所以父表的行是可以删除。)
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 举报，一经查实，本站将立刻删除。
转载请注明出处: https://daima100.com/10434.html
