What would be the outcome?
A. All the statements before the DELETE statement would be rolled back.
B. All the statements before the DELETE statement would be implicitly committed within the session.
C. All the statements up to the ALTER TABLE statement would be committed and the outcome of UPDATE statement would be rolled back.
D. All the statements up to the ALTER TABLE statement would be committed and the outcome of the UPDATE statement is retained uncommitted within the session.
Answer:A
What would be the outcome?
A. All the statements before the DELETE statement would be rolled back. B. All the statements before the DELETE statement would be implicitly committed within the session. C. All the statements up to the ALTER TABLE statement would be committed and the outcome of UPDATE statement would be rolled back. D. All the statements up to the ALTER TABLE statement would be committed and the outcome of the UPDATE statement is retained uncommitted within the session.
Explanation: Committing a transaction refers to making the changes to record in the database.