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