DBMS-Transaction Processing and Concurrency Control Questions and Answers

Practice Mode
Showing 10 of 66 questions
Q31
Level 3 transaction consistency adds consistent reads so that successive reads of a record will always give the same values
  • A TRUE
  • B FALSE
Answer: Option A
Q32
A lost update problem occurs when two transctions that access the same database items have their operations in a way that makes the value of some database item incorrect.
  • A TRUE
  • B FALSE
Answer: Option A
Q33
Serialisability describes the concurrent execution of serveral tranactions.
  • A TRUE
  • B FALSE
Answer: Option A
Q34
Unrepeadtable read occure when a transaction calculates some summary function over a set of data while other transactions are updating the data
  • A TRUE
  • B FALSE
Answer: Option A
Q35
It prevents access to a database record by a second transaction until the first transaction has completed all of its actions.
  • A TRUE
  • B FALSE
Answer: Option A
Q36
In a shrinking phase, a transaction releases all locks and cannot obtain any new lock.
  • A TRUE
  • B FALSE
Answer: Option A
Q37
A deadlock in a distributed system may be either local or global .
  • A TRUE
  • B FALSE
Answer: Option A
Q38
Which of the following is the activity of coordinating the actions of process that operate in parallel and access shared data?
  • A Transaction management
  • B Recovery management
  • C Concurrency control
  • D None of these
Answer: Option A
Q39
Which of the following is the ability of a DBMS to manage the various transactions that occur within the system ?
  • A Transaction management
  • B Recovery management
  • C Concurrency control
  • D None o these
Answer: Option B
Q40
Which of the following tranaction property?
  • A Isolation
  • B Durability
  • C Atomicity
  • D All of these
Answer: Option D

📚 More from Database

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