Briefly define the three problems that can occur because of concurrent processing that are addressed by resource locking

What will be an ideal response?


The three problems that can occur because of concurrent processing are dirty reads, nonrepeatable reads, and phantom reads. A dirty read occurs when a transaction reads a changed record that has not been committed to the database. If the change is cancelled before it is committed, then the read will contain incorrect data. A nonrepeatable read occurs when a transaction rereads data and finds modifications or deletions caused by another transaction. A phantom read occurs when a transaction rereads data and finds new rows that were inserted by another transaction since the prior read.

Business

You might also like to view...

Which of the following is most likely to create a conversational tone in a business message?

A) Text words B) Pompous language C) Plain language D) Intimacy E) Humor

Business

For a factory worker, all of the following are charged to Factory Overhead except:

a. the shift premium paid because the worker works the "graveyard" shift. b. the payroll taxes related to direct labor time. c. the overtime premium paid as a result of a "rush" job stipulated by the customer contract. d. the make-up guarantee paid because the employee did not reach the quota set forth in a modified wage plan.

Business

Store location planners look at a store's ________, the geographic zone that accounts for the majority of its sales and customers

A) trade area B) microenvironment C) primary market D) traffic paths E) target market

Business

The nine-cell attractiveness-strength matrix provides clear, strong logic for considering using

A. only business strength in allocating resources and investment capital to the different businesses. B. both resource fit and product strength in allocating resources and investment capital to its different businesses. C. both industry attractiveness and business strength in allocating resources and investment capital to its different businesses. D. both industry attractiveness and product strength in allocating resources and investment capital to its different businesses. E. only industry attractiveness in allocating resources and investment capital to its different businesses.

Business