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 .
答案:AE
解析:delete一次一个表,排除B,C错误,是因为only的原因,delete只能整行删除,排除D
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 .
答案:AE
解析:delete一次一个表,排除B,C错误,是因为only的原因,delete只能整行删除,排除D