DBMS-Transaction Processing and Concurrency Control Questions and Answers

Transaction Processing and Concurrency Control are crucial aspects of DBMS ensuring data integrity in multi-user systems. This topic includes database programming questions and answers covering ACID properties, concurrency problems, and locking mechanisms. Perfect for TCS, Infosys, and Oracle placements, these questions provide practical insight into how databases manage simultaneous transactions safely. Master these DBMS Transaction Processing questions with answers to excel in database management interviews and academic tests.

DBMS-Transaction Processing and Concurrency Control

Showing 10 of 66 questions

Questions per page:

51. Which of the following is validation-based concurrency control?

validation
write
read
all of these

Show Answer Report

52. The READ and WRITE operations of database within the same transaction must have

same timestamp
different timestamp
no timestamp
none of these

Show Answer Report

53. Locking can take place at the following levels:

Page level.
Database level
Terminated
Aborted

Show Answer Report

54. Locking can take place at the following levels:

Page level
Database level
Row level
all of these

Show Answer Report

55. In binary locking, there are

one state of locking
two states of locking
there states of locking
none of these

Show Answer Report

56. The way to undo the effects of a committed transaction is ?

Recovery
Compensating transaction
Roll back
None of these

Show Answer Report

57. Which of the following is the size of thedata item chosen as theunit of protection by a concurrency control program ?

Blocking factor
Granularity
Lock
None of these

Show Answer Report

58. A transaction can include is a problem resulting from concurrent execution of transaction ?

Read_item(X)
Wrte_item(X)
both (a) & (b)
none of these

Show Answer Report

DBMS-Transaction Processing and Concurrency Control Questions and Answers