If a schedule S can be transformed into a schedule S’ by a series of swaps of non-conflicting instructions, then S and S’ are(a) Non conflict equivalent(b) Equal(c) Conflict equivalent(d) Isolation equivalentThis question was addressed to me during an interview.This key question is from Serializability topic in division Transactions of RDBMS

If a schedule S can be transformed into a schedule S’ by a series of

1.	If a schedule S can be transformed into a schedule S’ by a series of swaps of non-conflicting instructions, then S and S’ are(a) Non conflict equivalent(b) Equal(c) Conflict equivalent(d) Isolation equivalentThis question was addressed to me during an interview.This key question is from Serializability topic in division Transactions of RDBMS
Answer» Right option is (c) Conflict EQUIVALENT The best I can EXPLAIN: If a schedule S can be TRANSFORMED into a schedule S’ by a series of swaps of non-conflicting instructions, then S and S’ are conflict equivalent. Not all serial SCHEDULES are conflict equivalent to each other.

Discussion

No Comment Found

Related InterviewSolutions

In ___________ isolation each transaction is given its own version of the database(a) Timestamp(b) Snapshot(c) Lock based(d) All of the mentionedI had been asked this question by my school teacher while I was bunking the class.This intriguing question originated from Transaction Isolation Levels in division Transactions of RDBMS
When is a timestamp allotted(a) When execution begins(b) When execution is taking place(c) When execution is completed(d) None of the mentionedThis question was posed to me in an online interview.I would like to ask this question from Transaction Isolation Levels topic in division Transactions of RDBMS
State true or false: All the isolation levels disallow dirty writes(a) True(b) FalseThis question was posed to me by my school teacher while I was bunking the class.I want to ask this question from Transaction Isolation Levels in division Transactions of RDBMS
___________ allows uncommitted data to be read(a) Read uncommitted(b) Serializable(c) Repeatable read(d) Read committedThis question was posed to me by my college professor while I was bunking the class.Origin of the question is Transaction Isolation Levels in chapter Transactions of RDBMS
________ allows only committed data to be read, but does not require repeatable reads(a) Read uncommitted(b) Serializable(c) Repeatable read(d) Read committedI had been asked this question during an interview.My question is from Transaction Isolation Levels in division Transactions of RDBMS
________ 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.(a) Read uncommitted(b) Serializable(c) Repeatable read(d) Read committedI had been asked this question during an online interview.I would like to ask this question from Transaction Isolation Levels in section Transactions of RDBMS
State true or false: Serializable level may allow both serializable and non-serializable executions(a) True(b) FalseI had been asked this question in quiz.I need to ask this question from Transaction Isolation Levels in section Transactions of RDBMS
Which of the following is a transaction isolation level as specified by SQL standard?(a) Serializable(b) Repeatable read(c) Read committed(d) All of the mentionedThe question was posed to me in an interview.The query is from Transaction Isolation Levels topic in chapter Transactions of RDBMS
Which of the following is not a type of a schedule?(a) Partial schedule(b) Dependent schedule(c) Recoverable schedule(d) None of the mentionedI got this question by my school principal while I was bunking the class.I'm obligated to ask this question of Transaction Isolation topic in division Transactions of RDBMS
If a schedule is equivalent to a serial schedule, it is called as a _________(a) Serializable schedule(b) Equivalent schedule(c) Committed schedule(d) None of the mentionedI have been asked this question during an online interview.My question is based upon Transaction Isolation in portion Transactions of RDBMS

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment