Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)
A.
You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate
the DEPT table.
B.
You can roll back the deletion of rows after the statement executes.
C.
You can NOT roll back the deletion of rows after the statement executes.
D.
An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will
display an error.
E.
It does not release the storage space used by the table.
F.
It releases the storage space used by the table.
Explanation:
:
A: The TRUNCATE TABLE Statement releases storage space used by the table,
D: Can not rollback the deletion of rows after the statement executes,
F: You must be the owner of the table or have DELETE ANY TABLE system privilege to truncate
the DEPT table.
Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 8-18