DBMS-Transaction Processing and Concurrency Control Questions and Answers

Practice Mode
Showing 10 of 66 questions
Q61
In which of the following schedule are the transactions performed one after another, one at a time ?
  • A Non-serial schedul
  • B Conflict serialisable schedule
  • C Serial schedule
  • D None of these
Answer: Option C
Q62
A shared lock exists when concurrent transations are granted the following access on the basis of a  common lock ;
  • A READ
  • B WRITE
  • C SHRINK
  • D UPDATE
Answer: Option A
Q63
In growing phase, a transaction acquires all the required locks
  • A by locking data
  • B without unlocking any data
  • C with unlocking any data
  • D None of these
Answer: Option B
Q64
Which of the following is an optimistic concurrency control method ?
  • A Validation-based
  • B Timestamp ordering
  • C Lock-based
  • D None of these
Answer: Option A
Q65
The basic variants of timestamp-based methods of concurrency control are
  • A Total timestamp ordering
  • B Partial timestamp ordering
  • C Multiversion timestamp ordering
  • D All of these
Answer: Option D
Q66
In optimistic methods, each transaction moves through the following phases:
  • A read phase
  • B validation phase
  • C write phase
  • 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