本文探讨了 SQL 中 DELETE 语句的使用及其效果，特别是当没有其他未提交的事务存在时，DELETE FROM sales; 语句的具体行为。文章详细解释了删除操作如何影响表中的数据，并指出被删除的行可以回滚。
QUESTION NO: 18
Evaluate the following SQL statements:
DELETE FROM sales;
There are no other uncommitted transactions on the SALES table.
Which statement is true about the DELETE statement?
A. It removes all the rows as well as the structure of the table
B. It removes all the rows in the table and deleted rows cannot be rolled back
C. It removes all the rows in the table and deleted rows can be rolled back
D. It would not remove the rows if the table has a primary key
Answer: C
答案解析：
参考：167：http://blog.youkuaiyun.com/rlhua/article/details/12887667
Explanation:
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
