Mark works as a Database Administrator for Neon Inc. He issues the following query to insert rows
in a table named Emp:
SELECT * FROM Emp
SET AUTOCOMMIT=0
INSERT INTO Emp VALUES(‘XXX’,’John’,04/02/1977)
INSERT INTO Emp VALUES(‘YYY’,’Richard’,03/01/1977)
ROLLBACK
How many rows will be inserted in the Emp table after the ROLLBACK statement has been
issued?
A.
Both rows will be inserted.
B.
No rows will be inserted.
C.
Only the second row will be inserted.
D.
Only the first row will be inserted.