Q4. (10 Points) Write a transaction to delete records for all the orders which were 'cancelled' and show the output then

[answerhappygod]

Q4 10 Points Write A Transaction To Delete Records For All The Orders Which Were Cancelled And Show The Output Then 1 (6.87 KiB) Viewed 22 times

Q4 10 Points Write A Transaction To Delete Records For All The Orders Which Were Cancelled And Show The Output Then 2 (22.19 KiB) Viewed 22 times

Q4 10 Points Write A Transaction To Delete Records For All The Orders Which Were Cancelled And Show The Output Then 3 (29.31 KiB) Viewed 22 times

Q4. (10 Points) Write a transaction to delete records for all the orders which were 'cancelled' and show the output then rollback and show the output

Tables > address address_status author Columns > author_id author_name > Indexes Foreign Keys Triggers book Columns book_id .title isbn13 language_id • num_pages publication_date publisher_id Indexes Foreign Keys Triggers book author Columns book_id • authorid > Ga Indexes Foreign Keys > Triggers > > 2

book_language country > customer customer_address customers > > > > 100% cust_order employees new_table offices orderdetails order_history order_line orders Los Columns orderNumber order Date requiredDate shippedDate status Action O V • comments > customerNum... > Indexes > Foreign Keys > Triggers order_status payments productlines products publisher shipping method > >