Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 398
|
Properties of ‘DELETE’ and ‘TRUNCATE’ commands indicate that
|
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 ‘DELETE’ and ‘TRUNCATE operation retrieval is easily 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 ‘DELETE’ and ‘TRUNCATE’ operation no retrieval is possible for the lost data
|
Question 398 Explanation:
TRUNCATE is a DDL command, it does not require a commit to make the changes permanent. Because of this reason the rows deleted by truncate could not be rollbacked. On the other hand, DELETE is a DML command, hence requires explicit commit to make its effect permanent.After performing a DELETE, you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.
Correct Answer: C
Question 398 Explanation:
TRUNCATE is a DDL command, it does not require a commit to make the changes permanent. Because of this reason the rows deleted by truncate could not be rollbacked. On the other hand, DELETE is a DML command, hence requires explicit commit to make its effect permanent.After performing a DELETE, you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo it.