Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Intelligent Databases Object Oriented Deductive Hypermedia Technologies

Authors: Kamran Parsaye, Mark Chignell, Setrag Khoshafian, Harry Wong

1st Edition

0471503452, 978-0471503453

More Books

Students also viewed these Databases questions

Question

What is the growth rate of GDP per capita?

Answered: 1 week ago