DBMS-Transaction Processing and Concurrency Control Questions and Answers

Practice Mode
Showing 10 of 66 questions
Q11
Log is a record of all transactions and the corresponding changes to the database.
  • A TRUE
  • B FALSE
Answer: Option A
Q12
Level 2 transaction consistency isolates from the updates of other transactions.
  • A TRUE
  • B FALSE
Answer: Option A
Q13
Level 2 transaction consistency isolates from the updates of other transactions.
  • A TRUE
  • B FALSE
Answer: Option A
Q14
Level 1 transaction is the minimum consistency requirement that allows a transaction to be recovered in the event of system failure.
  • A TRUE
  • B FALSE
Answer: Option A
Q15
A committed transaction that has performed updates transforms the database into a new cosnsistent state.
  • A TRUE
  • B FALSE
Answer: Option A
Q16
The objective of concurrency control is to schedule or arrange the transactions in such a way was to avoid any interference.
  • A TRUE
  • B FALSE
Answer: Option A
Q17
The objective of concurrency control is to schedule or arrange the transactions in such a way as to avoid any interference.
  • A TRUE
  • B FALSE
Answer: Option A
Q18
Incorrect analysis problem is also known as dirty read or unrepeatable read.
  • A TRUE
  • B FALSE
Answer: Option B
Q19
A consistent database state is one in which all data integrity cosnstraints are satisfied.
  • A TRUE
  • B FALSE
Answer: Option A
Q20
the serial execution always leaves the database in a consistent state although different results could be produced depending on the order of execution.
  • A TRUE
  • B FALSE
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test