Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
QUESTION
Suppose we have a table called Person (P#, name). What is the output from the following sequence of DML commands with ROLLBACK and COMMIT.
Suppose we have a table called Person (P#, name). What is the output from the following sequence of DML commands with ROLLBACK and COMMIT.
INSERT INTO Person VALUES (1, 'Mary');
INSERT INTO Person VALUES (2, 'Jack');
COMMIT;
INSERT INTO Person VALUES (3, 'Kate');
DELTE FROM Person WHERE P# =2;
INSERT INTO Person VALUES (4, 'Mike');
ROLLBACK;
SELECT * from Person;
