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/snzgh7tesql file can be found at https://files.fm/u/snzgh7te Login in to the LinuxOracle server and access the database using sqlplus in each of the

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

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!