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 to 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? Whywhy not
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
