Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | May 2017 |
Last Sign in: | 300 Weeks Ago, 2 Days Ago |
Questions Answered: | 66690 |
Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Exercise 17.8 Answer each of the follmving questions briefly.  The questions are based on
 following relational  schern.a:
Â
Ernp(                               string, age:  integer,  real, did: integer)
                 string, flooT:  integer)
Â
 on  fc)llowing update cornrnand:
Â
 (salary =   1.1                                           =
Â
Â
Â
1.  Give an  of    query that would conflict with this comrnand (in a  concurrency control sense) if both were run     the                                                                                              tim.e.  what could  go                            and how locking tuples would solve the  probleIll.
2.  Give  exarnple of  query or  cOHlInand that would conflict with this cOIl1ruand,   such that the conflict could not be resolved by just locking individual tuples or pages  but requires index locking.
Explain what index locking is and how it resolves the preceding  conflict.
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll