A concurrency-control policy such as this one leads to              performance since it forces transactions to wait for preceding transactions to finish before they can start.

Related MCQs

• A condition that occurs when two transactions wait for each other to unlock data is known as a(n)
•                        is popular for applications such as storage of log files in a database system since it offers the best write performance.
•                      is increasingly being used in server systems to improve performance by caching frequently used data, since it provides faster access than disk, with larger storage capacity than main memory.
•                        determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.
•                      are used to ensure that transactions access each data item in order of the transactions’          if their accesses conflict.
• Each of a pair of transactions has read data that is written by the other, but there is no data written by both transactions, is referred to as
• The                  keyword is used to access attributes of preceding tables or subqueries in the from clause.
• In a                            operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.
• When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj). Otherwise, Ti is rolled back (dies). This is
• When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti). This is