DBMS-Transaction Processing and Concurrency Control Questions and Answers

Practice Mode
Showing 10 of 66 questions
Q41
Which of the following ensures the consistency of the transactions ?
  • A Application programmer
  • B concurrency control
  • C Recovery management
  • D Transaction management
Answer: Option B
Q42
Which of the following ensures the durability of a transaction ?
  • A Application programmer
  • B Concurrency control
  • C Recovery management
  • D Transaction management
Answer: Option C
Q43
In a shrinking phase, a transaction:
  • A release all locks
  • B cannot obtain any new lock
  • C both (a) and (b)
  • D none of these
Answer: Option C
Q44
Which of the following ensures the atomicity of a transaction ?
  • A Application programmer
  • B Concurrency control
  • C Recovery management
  • D Tranasction management.
Answer: Option C
Q45
Which of the following ensures the isolation of a transaction ?
  • A Application programmer
  • B Concurrency control
  • C Recovery management
  • D Transaction management
Answer: Option B
Q46
Which of the following is a transaction state ?
  • A Active
  • B Commit
  • C Aborted
  • D All of these
Answer: Option D
Q47
The concurrency control has he following problem :
  • A lost updates
  • B dirty read
  • C unrepeatable read
  • D all o these
Answer: Option D
Q48
Which of the following is not a transaction management SQL command ?
  • A COMMIT
  • B SELECT
  • C SAVEPOINT
  • D ROLLBACK
Answer: Option C
Q49
Which of the following is a statement after which you cannot issue a COMMIT command ?
  • A INSER
  • B SELECT
  • C UPDATE
  • D DELETE
Answer: Option B
Q50
Timestamps must have following properties namely.
  • A uniqueness
  • B monotonicity
  • C both (a) and (b)
  • D none of these
Answer: Option C

📚 More from Database

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