Which statement should you execute when you do not want to rollback your data?

Options
- Delete
- Truncate


CORRECT ANSWER : Truncate

Discussion Board
TRUNCATE

TRUNCATE statement removes all rows from a table or specified partitions of a table, without logging the individual row deletions. TRUNCATE statement is similar to the DELETE statement with no WHERE clause; however, TRUNCATE statement is faster and uses fewer system and transaction log resources. TRUNCATE statement executes when you do not want to rollback your data.

Prajakta Pandit 03-8-2017 05:35 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.)


Advertisement