Install Oracle XE on your laptop and ensure to save all responses received from Oracle for each SQL query

executed. It is recommended to store all queries in a text editor, such as Notepad, as this practice can

significantly save time in the event of encountering any issues with Oracle. 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$?$