Question
a.
How long the transaction has computed, and how much longer the transaction will compute before it completes its designated task.
b.
How many data items the transaction has used.
c.
How many more data items the transaction needs for it to complete and how many transactions will be involved in the rollback.
d.
All of the above
Posted under Transactions DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is
Similar Questions
Discover Related MCQs
Q. __________ rollback requires the system to maintain additional information about the state of all the running transactions.
View solution
Q. Which of these is data type long literal?
View solution
Q. Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
View solution
Q. A transaction for which all committed changes are permanent is called:
View solution
Q. In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
View solution
Q. Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
View solution
Q. A transaction may not always complete its execution successfully. Such a transaction is termed
View solution
Q. Transaction processing is associated with everything below except
View solution
Q. Transaction management ensures ____________ and __________ properties.
View solution
Q. ____________ is an interface between low level database and application program.
View solution
Q. Which of the following are functions of Database Manager ?
1. Interacting with File Manager
2. Creating Queries to Access data
3. Security Enforcement
4. Database Definition and Schema Generation
View solution
Q. Who detects the failure of the system and restore the database to consistent state ?
View solution
Q. A traditional data administrator performs which of the following roles?
View solution
Q. Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
View solution
Q. Which of the following is the preferred way to recover a database after a system failure?
View solution
Q. Concurrency control is important for which of the following reasons?
View solution
Q. A shared lock allows which of the following types of transactions to occur?
View solution
Q. Locking may cause which of the following problems?
View solution
Q. Performance analysis and tuning is which of the following?
View solution
Q. Which of the following could cause data to be unavailable?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
