Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 transacon in session 1. Following this, is the new employee's data visible in session 2?
Provide an explanaon for your observaon.
15. Sll in session 1, update the new employees name to ARAS, but do not commit the change. Is the
modificaon 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 employees name to TAYLOR without comming the change. Concurrently, in
session 2, atempt to change the same employees 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 acon?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions