本文解析了数据库操作中的DELETE和TRUNCATE命令的区别，重点介绍了这两个命令在处理有引用完整性约束的表时的行为，并解释了如何正确使用ON DELETE规则。
一、原题
二、题目翻译
三、题目解析
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
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和TRUNCATE命令哪两个句子是正确的？(选择两个)
A.DELETE一次只能用于移除一个表的行。
B.DELETE一次只能用于移除多个表的行。
C.DELETE只能用于删除有引用完整性约束的父表。
D.DELETE可以用于删除指定列的数据以及完整的行。
E.DELETE和TRUNCATE可以用于有引用完整性约束ON DELETE规则的父表。
A.DELETE一次只能用于移除一个表的行。
B.DELETE一次只能用于移除多个表的行。
C.DELETE只能用于删除有引用完整性约束的父表。
D.DELETE可以用于删除指定列的数据以及完整的行。
E.DELETE和TRUNCATE可以用于有引用完整性约束ON DELETE规则的父表。
三、题目解析
表可以使用ON DELETE CASCADE选项（当删除父表数据时，子表数据也一起删除）或ON DELETE CASCAD SET NULL选项（当删除父表数据时，子表相关的列设置为NULL）,
有这些选项，就可以在父表中直接删除相关的行，而不会报外键约束错误。
有这些选项，就可以在父表中直接删除相关的行，而不会报外键约束错误。
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
