Question
a.
Total
b.
Partial
c.
Time
d.
Commit
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. __________ rollback requires the system to maintain additional information about the state of all the running transactions.
Similar Questions
Discover Related MCQs
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
Q. The transaction log includes which of the following?
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!
