Question: Create another table with the same types as Cust but without the customer address. Call this table Cust1. Use attribute names cnum for customer number

 Create another table with the same types as Cust but without

Create another table with the same types as Cust but without the customer address. Call this table Cust1. Use attribute names cnum for customer number and bal for balance. Load the table with the data you have in the Cust table with one less row. Use an INSERT INTO SELECT with appropriate attributes and an appropriate WHERE clause. Display the resulting table. If it appears ok, COMMIT your work. Assuming that you have COMMITted in step b, delete about half of your rows from Custl C"DELETE FROM Cust1 WHERE bal some value, etc.D). Show the table after you have deleted the rows. Undelete the rows with ROLLBACK. 2-5. a. b. c. d. e. f. g. h. i. j. Display the table with the reinstated rows. Delete one row from the Custl table and SAVEPOINT point1. Display the table. Delete another row from the table and SAVEPOINT point2. Display the table. ROLLBACK to SAVEPOINT point 1, display the table, and explain what is happening. Try to ROLLBACK to SAVEPOINT point2 and see what happens and explain it

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!