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;

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question