1Z0-007题库的一个错误，关于truncate table需要的系统权限

闲看1Z0-007的题库，发现了一个错误。

 

Q: 14 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.

Answer: A, D, F

 

答案F是不对的。因为truncate其他用户的表，需要的是“DROP ANY TABLE”，不是“DELETE ANY TABLE”。

 

其实也很好理解，因为truncate是DDL而不是DML。

不知道为什么会有这样的错误。