DBMS-Transaction Processing and Concurrency Control Questions and Answers

Practice Mode
Showing 10 of 66 questions
Q1
The transaction cosnsists of all the operations executed between the beginning and end of the transaction.
  • A TRUE
  • B FALSE
Answer: Option A
Q2
A transaction is a program unit, which can either be embedded withing an applicant program or can be specified interctively via a high-level query language such as SQL.
  • A TRUE
  • B FALSE
Answer: Option A
Q3
A transaction that is either committed or aborted is said to be terminated.
  • A TRUE
  • B FALSE
Answer: Option A
Q4
A transaction that is either committed or aborted is said to be terminated.
  • A TRUE
  • B FALSE
Answer: Option A
Q5
Atomic transaction is transactions in which either all actions associated with the transaction are executed to completion, or none  are performed.
  • A TRUE
  • B FALSE
Answer: Option A
Q6
The effects of a successfully completed transaction are permanently recorded in the database and must not be lost because of a subsequent failure.
  • A TRUE
  • B FALSE
Answer: Option A
Q7
Level  0 transactions are recoverable.
  • A TRUE
  • B FALSE
Answer: Option B
Q8
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
Q9
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
Q10
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

📚 More from Database

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