Question: sql file can be found at https://files.fm/u/snzgh7te Login in to the Linux Oracle server and access the database using sqlplus in each of the two
sql file can be found at https://files.fm/u/snzgh7te

Login in to the Linux Oracle server and access the database using sqlplus in each of the 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 terminals Create transaction1 log file using in 1st terminal: SPOOL 4-FirstLastName-Lab_T1.txt Create transaction 2 log file using in 2nd terminal: SPOOL 4-FirstLastName-Lab_T2.txt . 1. Execute the following statements and observe: Terminal 2 Terminal 1 1 insert into team values (7, Lakers,3, LA,O: 2 3 commit; 4 insert into team values (7, 'Knicks' , 8. 'NY, 0); commit a. (5 points) What happens after step 2 and why? b. (5 points) What happens after step 3 and why
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
