可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Evaluate the SQL statement: TRUNCATE T


Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()

  • 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
参考答案
参考解析:
分类:1Z0-007题库