多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
正确答案:A,D,F
答案解析:
进入题库查看解析

微信扫一扫手机做题