Given below are the SQL statements executed in a user session:
CREATE TABLE product
(pcode NUMBER(2),
pnameVARCHAR2(10));
INSERT INTO product VALUES(1, ‘pen’);
INSERT INTO product VALUES (2,’pencil);
SAVEPOINT a;
UPDATE product SET pcode = 10 WHERE pcode = 1;
SAVEPOINT b;
DELETE FROM product WHERE pcode = 2;
COMMIT;
DELETE FROM product WHERE pcode=10;
ROLLBACK TO SAVEPOINT a;
Which statement describes the consequences?
A.
No SQL statement would be rolled back.
B.
Both the DELETE statements would be rolled back.
C.
Only the second DELETE statement would be rolled back.
D.
Both the DELETE statements and the UPDATE statement would be rolled back.
Answer A is correct because
Reason : Use of the COMMIT statement to end your current transaction and make permanent all changes performed in the transaction. A transaction is a sequence of SQL statements that Oracle Database treats as a single unit. This statement also erases all savepoints in the transaction and releases transaction locks.
Thankfulness to my father who informed me concerning this web site, this blog is truly remarkable.|