Sail E0 Webinar
Question
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
Options:
A .  The contents of OTHERTABLE will be deleted
B .  The contents of both OTHERTABLE and MYTABLE will be deleted
C .  The contents of OTHERTABLE will be deleted, as will be all the contents of MYTABLE whose ID is 1
D .  The database will remain unchanged to all users except the one that executes these queries.
E .  The database will remain unchanged
Answer: Option E

Submit Your Solution Below and Earn Points !
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers