dump schemes have been developed that allow transactions to be active while the dump is in progress.

Related MCQs

• A dump of the database contents is also referred to as an                            dump.
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• 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.
•                      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
• Instead of locking index leaf nodes in a two-phase manner, some index concurrency- control schemes use                        on individual key values, allowing other key values to be inserted or deleted from the same leaf.
• The                        policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed.
• Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:
• Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:
• Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?