HomeworkLib
Question

Figure out the correct option. If there any idea why upgrading occurs in DBMS then 1....

Figure out the correct option. If there any idea why upgrading occurs in DBMS then 1. each transaction is waiting for a locked item that never unlocks. 2. a read_lock operation is issued after a write_lock operation. 3. a write_lock operation is issued after a read_lock operation. Can you find the best response out of three above?

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Ans. The correct option is

3. A write_lock operation is issued after a read_lock operation because without read_lock operation write_lock operation cannot be executed.

A transaction is an atomic unit which consists of one or more SQL statements. It begins with first executable SQL statements and ends when it is committed or rolled back. Until the statement is committed in transaction it can be rolled back and all of the changes of the statement can be undone.

Example: In a transaction,

read X=100

X= 100 + 500

write X=600

In the above transaction first read X=100 then 500 is added which is upgraded and added with 100 then it is upgraded and it is added and write 600 and the new amount is added in the particular account.

So, a write_lock operation is issued after a read_lock operation is executed.

0 0
Add a comment
Know the answer?
Add Answer to:
Figure out the correct option. If there any idea why upgrading occurs in DBMS then 1....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Correct Answer is provided. I just can't figure out how to get there. Question 2 0 out of 10 points A market value weig...

    Correct Answer is provided. I just can't figure out how to get there. Question 2 0 out of 10 points A market value weighted index has three stocks in it, call them A, B, and C, priced at 88, 94, and 41 per share. Each firm has 324, 206 and 148 thousand shares outstanding, respectively. The value of the index at close of x trading day is 763. At this time, the index decides to remove stock C from the...

  • Please help with any or all problems I can’t seem to figure them out thanks -#1...

    Please help with any or all problems I can’t seem to figure them out thanks -#1 points SerCP10 13.P046 A bat can detect small objects, such as an insect, whose size is approximately equal to 7.99 x 10* Hz, and if the speed of sound in air is 343 m/s, what is the smalest insect a bat can detect? My Notes Ask Your Teack one wavelength of the sound the bat makes. If bats emit a chirp at a frequency...

  • Need to figure out part b. The following three independent sets of facts relate to contingent...

    Need to figure out part b. The following three independent sets of facts relate to contingent liabilities: 1. In November of the current year, an automobile manufacturing company recalled all pickup trucks manufactured during the past two years. A flaw in the battery cable was discovered and the recall provides for replacement of the defective cables. The estimated cost of this recall is $2.3 million. 2. The EPA has notified a company of violations of environmental laws relating to hazardous...

  • Cyber Security EXERCISE 1: One very simple tool to figure out if a “host” (any device...

    Cyber Security EXERCISE 1: One very simple tool to figure out if a “host” (any device with an address on a network) is turned on and communicating over the network is “PING.” Of course, system administrators can prevent hosts from responding to pings. DO: Check out the website: In Kali, open up the browser (Iceweasel). In the address bar type the URL http://www.foo.com to notice that there is a site configured with that domain. Open up the command line on...

  • Hello! Help please, I THINK that's the figure based on what I could find out and...

    Hello! Help please, I THINK that's the figure based on what I could find out and based on the question, but my professor never gave us Chapter 13 to read for. Regardless, the first question has got me confused. What experiments exactly? The second question I can do on my own but I'm unsure if I have the right idea. Thank you! Essay Questions (30 points): Answer in full sentences, include textbook page numbers to support your information, and reference...

  • Part I. Perspective Experiments. 1. This problem may require the use of a flashlight and some...

    Part I. Perspective Experiments. 1. This problem may require the use of a flashlight and some cut out paper objects. By studying the nature of shadows cast you can get an idea of how the perspective correspondence works. After some experiments, use your three-dimensional imagination to figure out the answers. Below is a list of geometric shapes, properties of geometric shapes, and rela- tionships between geometric objects. What happens to these shapes, properties, and relationships under a perspective correspondence? For...

  • Java 1. Develop a program to emulate a purchase transaction at a retail store. This program...

    Java 1. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual line item of merchandise that a customer is purchasing. The Transaction class will combine several LineItem objects and calculate an overall total price for the line item within the transaction. There will also be two test classes, one for the LineItem class and one for the...

  • Can anyone help me out with any of these please? Lab Day & Time: Physics 1080...

    Can anyone help me out with any of these please? Lab Day & Time: Physics 1080 Forces and Traction: Prelab 50 2 Part 1 100 1. You are standing outside your house and walk 100m north. You turn right and walk 50m east. Finally, you turn right again and walk 100m south. a. How far have you walked? b. How far are you from your starting point in the north/south direction? c. How far are you from your starting point...

  • Option 1: Authentication System For security-minded professionals, it is important that only the appropriate people gain...

    Option 1: Authentication System For security-minded professionals, it is important that only the appropriate people gain access to data in a computer system. This is called authentication. Once users gain entry, it is also important that they only see data related to their role in a computer system. This is called authorization. For the zoo, you will develop an authentication system that manages both authentication and authorization. You have been given a credentials file that contains credential information for authorized...

  • (DBA Level )Tick the right answer (only 1 is correct): 1.         Which of the following...

    (DBA Level )Tick the right answer (only 1 is correct): 1.         Which of the following does NOT apply to quantitative research? It uses the scientific method It gives rise to less reliable data than qualitative research It aims to describe, explain and predict phenomena Its methods are tighter and more rigorous than in qualitative research 2.         What is the correct ordering of the stages involved in planning research? Formulate the hypothesis, carry out the study, design the study,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT