Similar Collections

.

questions

Title
State true or false: If I = read(Q) and J = read(Q) then the order of I and J does not matter
State true or false: If I = read(Q) and J = write(Q) then the order of I and J does not matter
Which of the following is the most expensive method
A transaction that performs only one operation is called as a _________
The phenomenon in which one failure leads to a series of transaction rollbacks is called as ________
State true or false: Every cascadeless schedule is also recoverable
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
State true or false: Transactions can only run serially
Which of the following are the advantages of transaction concurrency
The average time for a transaction to be completed after it has been submitted is called as __________
If a schedule is equivalent to a serial schedule, it is called as a _________
Which of the following is not a type of a schedule
Which of the following is a transaction isolation level as specified by SQL standard
State true or false: Serializable level may allow both serializable and non-serializable executions
________ 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
________ allows only committed data to be read, but does not require repeatable reads
___________ allows uncommitted data to be read
State true or false: All the isolation levels disallow dirty writes
When is a timestamp allotted
In ___________ isolation each transaction is given its own version of the database
total questions: 143

Questions

143

Views

1726

Best Answers

299

Points

5