Choose two.
You execute this command:
TRUNCATE TABLE depts;
Which two are true?
A) It drops any triggers defined on the table.
B) It retains the indexes defined on the table.
C) It retains the integrity constraints defined on the table.
D) A ROLLBACR statement can be used to retrieve the deleted data.
E) It always retains the space used by the removed rows.
F) A FLASHBACK TABLE statement can be used to retrieve the deleted data.
Answer::BC
(解析:基本的考点。)
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。
原创声明:本文系作者授权腾讯云开发者社区发表,未经许可,不得转载。
如有侵权,请联系 cloudcommunity@tencent.com 删除。