What does truncating a table does?

Options
- Data alone deleted, Performs an automatic commit
- Data alone deleted, Doesn’t perform automatic commit
- Table structure + Data are deleted
- Table structure alone deleted, Performs an automatic commit

CORRECT ANSWER : Data alone deleted, Performs an automatic commit

Discussion Board
Explanation.

Answer : Data alone deleted, Performs an automatic commit.

The SQL TRUNCATE TABLE command is used to delete complete data from an existing table. TRUNCATE TABLE quickly deletes all records in a table by deallocating the data pages used by the table.

Jayesh Sonar 03-2-2015 01:17 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲