Quiz Sagar...
Menu

Firoz Ansari

5 years ago
Like 1411
Questions 51
Contests 8

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...