Sailors (S ID, S name, S rating, S Age) Boats (B_ID, B_name, B_color) Reservations (S ID, B ID, R_date) 1. Execute the following statements and observe: Terminal Terminal 1delete from reserves where sid- 74 3 comit insert into In this section, you will open TWO separate terminals: imsert imto boats values (106,Seagull, yellow select elect rol select from boats 13 insert into sailors values (97. Hook. 10 '55. 15 17 rollback 19 selectfrom insert into boats values (10 insert into sailors values (97, Billy, 8 select from sailors elect Login in to the Linux Oracle server and access the database using sqlplus in each of the 23 24 select from sailors select from boats two terminals Display the SQL commands using: SET ECHO ON for each of the two terminals To enable manual commit for changes: SET AUTOCOMMIT OFF for each of the two a. (5 points) What happens after step 2 and why? b. (5 points) What happens after step 3 and why? C. (5 points) What happens after step 7 and why? d. (5 points) What happens after step 12 and why? e. (5 points) Explain the results (wait to see) of steps 13 to 16 and why? f. (5 points) What happens after step 17 and why? g. (5 points) What happens after step 21 and why? h. (5 points) What happens after step 24 and why? terminals Create transaction1 log file using in 1st terminal: SPOOL Create transaction 2 log file using in 2nd terminal: SPOOL 4-FirstLastName-Lab_T2.txt T1.txt