Question
a.
Increased throughput
b.
Increased utilization
c.
Reduces average response time
d.
All of the mentioned
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. Which of the following are the advantages of transaction concurrency?
Similar Questions
Discover Related MCQs
Q. The average time for a transaction to be completed after it has been submitted is called as __________
View solution
Q. If a schedule is equivalent to a serial schedule, it is called as a _________
View solution
Q. Which of the following is not a type of a schedule?
View solution
Q. Which of the following is a transaction isolation level as specified by SQL standard?
View solution
Q. State true or false: Serializable level may allow both serializable and non-serializable executions
View solution
Q. ________ allows only committed data to be read and further requires that no other transaction is allowed to update it between two reads of a data item by a transaction.
View solution
Q. ________ allows only committed data to be read, but does not require repeatable reads
View solution
Q. ___________ allows uncommitted data to be read
View solution
Q. State true or false: All the isolation levels disallow dirty writes
View solution
Q. When is a timestamp allotted
View solution
Q. In ___________ isolation each transaction is given its own version of the database
View solution
Q. What is the disadvantage of locking?
View solution
Q. Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction ?
View solution
Q. A transaction is delimited by statements (or function calls) of the form __________
View solution
Q. Identify the characteristics of transactions
View solution
Q. Which of the following has “all-or-none” property ?
View solution
Q. The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as
View solution
Q. The property of transaction that persists all the crashes is
View solution
Q. __________ states that only valid data will be written to the database.
View solution
Q. The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.
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!
