DBMS-Transaction Processing and Concurrency Control Questions and Answers

Practice Mode
Showing 10 of 66 questions
Q51
Which of the following is validation-based concurrency control?
  • A validation
  • B write
  • C read
  • D all of these
Answer: Option D
Q52
The READ and WRITE operations of database within the same transaction must have
  • A same timestamp
  • B different timestamp
  • C no timestamp
  • D none of these
Answer: Option A
Q53
Locking can take place at the following levels:
  • A Page level.
  • B Database level
  • C Terminated
  • D Aborted
Answer: Option D
Q54
Locking can take place at the following levels:
  • A Page level
  • B Database level
  • C Row level
  • D all of these
Answer: Option D
Q55
In binary locking, there are
  • A one state of locking
  • B two states of locking
  • C there states of locking
  • D none of these
Answer: Option B
Q56
The way to undo the effects of a committed transaction is ?
  • A Recovery
  • B Compensating transaction
  • C Roll back
  • D None of these
Answer: Option C
Q57
Which of the following is the size of thedata item chosen as theunit of protection by a concurrency control program ?
  • A Blocking factor
  • B Granularity
  • C Lock
  • D None of these
Answer: Option B
Q58
A transaction can include is a problem resulting from concurrent execution of transaction ?
  • A Read_item(X)
  • B Wrte_item(X)
  • C both (a) & (b)
  • D none of these
Answer: Option C
Q59
Which of the following is a problem resulting from concurrent execution of transaction ?
  • A Incorrect analysis
  • B Multiple update
  • C Ucommitted dependency
  • D all of these
Answer: Option B
Q60
Which of the following is not a deadlock handling strategy ?
  • A Timeout
  • B Deadlock annihilation
  • C Deadlock prevention
  • D Deadlock detection
Answer: Option B

📚 More from Database

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