Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate that
- After the execution of ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost data.
- After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data, while TRUNCATE do not allow it.
- After the execution of ‘TRUNCATE’ operation, COMMIT and ROLLBACK statements cannot be performed to retrieve the lost data, while ‘DELETE’ allow it.
- After the execution of ‘TRUNCATE’ operation, COMMIT and ROLLBACK statements cannot be performed to retrieve the lost data, while ‘DELETE’ allow it.
- option2
Clear All
Loading...