Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Name a database vendor (eg, Access, Microsoft SQL Server, Sybase, Oracle, etc.) to which you think your answers in Part III apply. 1. If one
Name a database vendor (eg, Access, Microsoft SQL Server, Sybase, Oracle, etc.) to which you think your answers in Part III apply. 1. If one row in a table is updated, how many rows in that table are locked? 2. In the SQL example below, indicate where locking starts and finishes as a result of the execution of these state- ments. Indicate what type of locking is in effect. BEGIN TRANSACTION SELECT Title [Assume it returns War and Peace'] FROM Book WHERE Book_ID - 359; -time = T: UPDATE Book SET Title = 'Meanderings of a Spendthrift WHERE Book_ID = 359; -time = T2 SELECT Title FROM Book WHERE Book_ID = 3593 COMMIT TRANSACTION; -time = Ts 3. In the SQL example above, will the last SELECT find the same data as the first one? Explain why. In the SQL example above, if another process performs a SELECT on the Book table, what title will it see for Book_id 359 if that select is attempted? - at time Tu? - at time T2 - at time T3? 5. In the SQL example above, if another process attempts to UPDATE the row in Book with Book_id 359, what will happen if that update is attempted? - at time Ta? - at time T2? - at time T3
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