Database and Database users - Characteristics of the DB approach - Sharing of data and multiuser Transaction Processing

5 important questions on Database and Database users - Characteristics of the DB approach - Sharing of data and multiuser Transaction Processing

How does concurrency control help in multiuser transaction?

It ensures that several users trying to update the same data do so in controlled manner so that result of update is correct.

What are on-line transaction processing (OLTP) applications? Explain through example.

For example, when several reservation clerks try to assign a seat on an airline flight, the DBMS should ensure that each seat can be accessed by only one clerk at a time for assignment to a passenger.

What is a transaction?

It is an executing program or process that includes one or more database access, such as reading or updating of database records.
  • Higher grades + faster learning
  • Never study anything twice
  • 100% sure, 100% understanding
Discover Study Smart

What is the use of isolation property?

It ensures that each transaction appears to execute in isolation from other transactions, even though hundreds of transactions may be executing concurrently.

What are the uses of atomicity property?

The atomicity property ensures that either all the database operations in a transaction are executed or none are.

The question on the page originate from the summary of the following study material:

  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
Trustpilot Logo