The final report for this handson activity should comprehensively include the answers to the questions, the SQL queries executed, and

the responses received for each query.

$12.$ Begin by opening two SQL$*$Plus sessions on your laptop. Ensure that both sessions have the

AUTOCOMMIT feature turned off.

$13.$ In the first session, insert a record for a new employee named ARROW into the STAFF table. Can you

view the newly entered data in both session $1$ and session $2?$ Why or why not?

$14.$ Commit the transac$$on in session $1.$ Following this, is the new employee's data visible in session $2?$

Provide an explana$$on for your observa$$on$.$

$15.$ S$$ll in session $1,$ update the new employee$$s name to ARAS, but do not commit the change. Is the

modifica$$on observable in session $1?$ How about in session $2?$ Why?

$16.$ Execute a COMMIT in session $1.$ Does session $2$ reflect the change now? Why?

$17.$ In session $1,$ change the employee$$s name to TAYLOR without commi$$ng the change. Concurrently, in

session $2,$ atempt to change the same employee$$s name to DAVE. What outcome do you observe in

session $2?$

$18.$ Commit the change in session $1.$ How does this affect the data viewed in session $2?$

$19.$ In session $2,$ perform a ROLLBACK. What is the status of the new employee's data following this ac$$on$?$