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.