OCP 1Z0-051 170

（170）Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)

A. DELETE can be used to remove only rows from only one table at a time.

B. DELETE can be used to remove only rows from multiple tables at a time.

C. DELETE can be used only on a table that is a parent of a referential integrity constraint.

D. DELETE can be used to remove data from specific columns as well as complete rows.

E. DELETE and TRUNCATE can be used on a table that is a parent of a referential integrity constraint having ON DELETE rule .

答案：（A、E）

解析：

E，就是指ON DELETE CASCADE或ON DELETE SET NULL

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

转载于:http://blog.itpub.net/17013648/viewspace-1172121/