Oracle - Database Programming and SQL
Run the following queries in Oracle Application Express. Paste a copy of each query into this word document below the questions or notepad .txt file, save and return in via TalonNet:
SECTION 14 LESSON 1 - Database Transactions
Ex. 1, 2, 3
1. Define the terms COMMIT, ROLLBACK, and SAVEPOINT as they relate to data transactions.
2. What data will be committed after the following statements are issued?
INSERT INTO R values (5, 6);
SAVEPOINT my_savepoint_1;
INSERT INTO R values (7, 8);
SAVEPOINT my_savepoint_2;
INSERT INTO R values (9, 10);
ROLLBACK TO my_savepoint_1;
INSERT INTO R values (11, 12);
COMMIT;
3. Construct a SQL statement for the DJ on Demand D_SONGS table that deletes the song "All These Years," inserts a new Country song called 'Happy Birthday Sunshine' by "The Sunsets" with a duration of 4 min and an ID = 60. Make sure that all data can be recovered before any changes to the table are made.