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
3709
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
