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

最新推荐文章于 2023-05-04 09:36:45 发布

今年我18

最新推荐文章于 2023-05-04 09:36:45 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： 1z0-051 文章标签： 1z0-051

本文链接：https://blog.youkuaiyun.com/dwj19830118/article/details/50961937

1z0-051 专栏收录该内容

175 篇文章

订阅专栏

本文探讨了SQL中DELETE和TRUNCATE命令的区别与使用场景。DELETE命令用于从一个表中移除指定行，而TRUNCATE则用于清空整个表的数据。DELETE可以配合条件表达式使用，而TRUNCATE不能。两者在事务处理和性能方面也有不同。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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