OCP-1Z0-051 补充题库第1题 TRUNCATE命令的使用

最新推荐文章于 2021-01-18 20:00:20 发布

原创

最新推荐文章于 2021-01-18 20:00:20 发布 · 4.3k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#OCP-1Z0-051 #TRUNCATE #ROLLBACK #权限 #11g

本文详细解析了Oracle数据库中的TRUNCATE TABLE命令，指出它会释放表的存储空间，但执行后无法进行ROLLBACK操作。同时，执行TRUNCATE命令需要具备表的所有权或DELETE ANY TABLE系统权限。

一、原题

Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)
A. It releases the storage space used by the table.
B. It does not release the storage space used by the table.
C. You can roll back the deletion of rows after the statement executes.
D. You can NOT roll back the deletion of rows after the statement executes.
E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will
display an error.
F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate
the DEPT table

答案： A,D,F