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
答案解析:有
微信扫一扫手机做题