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

The correct answer is A. It releases the storage space used by the table. D. You can NOT roll back the deletion of rows after the statement executes. F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate. 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 Incorrect answer:

Manipulating Data (DML)

Question

Evaluate the SQL statement:

TRUNCATE TABLE DEPT; Which three are true about the SQL statement? (Choose three.)

Options

AIt releases the storage space used by the table.
BIt does not release the storage space used by the table.
CYou can roll back the deletion of rows after the statement executes.
DYou can NOT roll back the deletion of rows after the statement executes.
EAn attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will
FYou must be the owner of the table or have DELETE ANY TABLE system privileges to truncate

How the community answered

(51 responses)

A
82% (42)
B
12% (6)
C
4% (2)
E
2% (1)

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 Incorrect answer:

Topics

#TRUNCATE#DDL#storage space#rollback

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice