Question: Evaluate the SQL statement: TRUNCATE TABLE BOOKS; Which statement is true about the SQL statement? a . It does not release the storage space used
Evaluate the SQL statement:
TRUNCATE TABLE BOOKS;
Which statement is true about the SQL statement?
a
It does not release the storage space used by the table
b
You can roll back the deletion of rows after the statement executes
c
An attempt to use DESCRIBE on the BOOKS table after the TRUNCATE statement executes will display an error
d
You must be the owner of the table or have DELETE ANY TABLE system privilege to truncate the BOOKS table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
