Question: In your new job as a software developer, you are tasked to write a report that will utilize several long running SQL statements. For example,

In your new job as a software developer, you are tasked to write a report that will utilize
several long running SQL statements. For example, you are required to read a large table
using multiple SQL statements. You start to think about the other users of the DB and
how they are actively changing the database while your multiple SQL statements are
running. For each question below, discuss how each consistency levels (read
uncommitted, read committed, repeatable read, and serializable ) could impact the results
(include 1 to 2 sentences for each these levels and for each problem). BE SPECIFIC to
this situation (do not repeat what Wikipedia tells you, tell me how each level could
impact the results here).
a) Should you be concerned that the data within a single SQL statement will contain work
that is not committed?
b) Should you be concerned that rows that were committed (by other transactions) during
the execution of your first SQL statement will be visible when the second SQL statement
starts? Why/why not

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 Programming Questions!