Question
a.
Serializability order
b.
Direction graph
c.
Precedence graph
d.
Scheduling scheme
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. A ___________of the transactions can be obtained by finding a linear order consistent with the partial order of the precedence graph.
Similar Questions
Discover Related MCQs
Q. State true or false: If I = read(Q) and J = read(Q) then the order of I and J does not matter.
View solution
Q. State true or false: If I = read(Q) and J = write(Q) then the order of I and J does not matter.
View solution
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
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!
