What will happen at the end of the following sequence of SQL commands?
BEGIN TRANSACTION
DELETE FROM MYTABLE WHERE ID=1
DELETE FROM OTHERTABLE
ROLLBACK TRANSACTION
The database will remain unchanged
Correct:
The database will remain unchanged
Explanation:
Given that this set of queries is contained within a transaction and that the transaction is rolled back at the end, no changes will be made to the database. Therefore, Answer E is correct.