试题详情
多项选择题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

  • B,D,F
  • 关注下方微信公众号,在线模考后查看

热门试题