QUESTION: Which three statements/commands would cause a transaction to end? (Choose three.) A. COMMIT B. SELECT C. CREATE D. ROLLBACK E. SAVEPOINT Answer: A,C,D A transaction is a unit of work containing SQL statements. Transactions end when they are committed or rolled back, or when a DDL statement is issued. COMMIT will make the changes … Continue reading Ending a Transaction

QUESTION: Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session? SQL> CREATE TABLE product 2 (pcode NUMBER(2), 3 pname VARCHAR2(10)); Table created. SQL> INSERT INTO product VALUES (1,'pen'); 1 row created. SQL> INSERT INTO product VALUES (2,'pencil'); 1 row created. SQL> SAVEPOINT a; Savepoint created. SQL> … Continue reading Transactions and SAVEPOINT