Answered step by step
Verified Expert Solution
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.
Begin by opening two SQLPlus sessions on your laptop. Ensure that both sessions have the
AUTOCOMMIT feature turned off.
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 and session Why or why not?
Commit the transacon in session Following this, is the new employee's data visible in session
Provide an explanaon for your observaon
Sll in session update the new employees name to ARAS, but do not commit the change. Is the
modificaon observable in session How about in session Why?
Execute a COMMIT in session Does session reflect the change now? Why?
In session change the employees name to TAYLOR without comming the change. Concurrently, in
session atempt to change the same employees name to DAVE. What outcome do you observe in
session
Commit the change in session How does this affect the data viewed in session
In session 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started