Select from following answers:- The DELETE statement logs information on each row deleted.
- The TRUNCATE TABLE statement logs information on each row deleted.
- The TRUNCATE TABLE statement executes fast and requires fewer resources on the server.
- Only 1 and 3
- All Above
DELETE is DML operation which logged row by row in memory; whereas TRUNCATE removes entire table data at a time and logs information one time for table
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator