Question
a.
True
b.
False
c.
May be
d.
Can't say
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. State true or false: If I = read(Q) and J = write(Q) then the order of I and J does not matter.
Similar Questions
Discover Related MCQs
Q. Which of the following is the most expensive method?
View solution
Q. A transaction that performs only one operation is called as a _________
View solution
Q. The phenomenon in which one failure leads to a series of transaction rollbacks is called as ________
View solution
Q. State true or false: Every cascadeless schedule is also recoverable
View solution
Q. A ___________ is one where, for each pair of transactions Ti and Tj such that Tj reads a data item previously written by Ti , the commit operation of Ti appears before the commit operation of Tj
View solution
Q. State true or false: Transactions can only run serially
View solution
Q. Which of the following are the advantages of transaction concurrency?
View solution
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
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!
