• edited by
23 views
1 1 vote

Which of the following scenarios best describes a violation of the consistency property?

  1. A transaction completes but leaves the database in a state where total credits $\neq$ total debits.
  2. Two transactions read and write the same record simultaneously.
  3. A transaction partially runs due to a crash.
  4. Data from a committed transaction is deleted after a restart.

Please log in or register to answer this question.

Position:
Show:

Related questions

1 1 vote
0 0 answers
27
27 views
Shubham Sharma 2 asked Sep 15
27 views
What is the initial value of top in an empty stack implemented using an array?$0$$-1$$1$Depends on stack size
0 0 votes
0 0 answers
17
17 views
Shubham Sharma 2 asked Sep 15
17 views
A banking transaction commits successfully, but a system crash occurs immediately afterward. Which mechanism ensures durability?LockingPartial commitTransaction isolation...
0 0 votes
0 0 answers
20
20 views
Shubham Sharma 2 asked Sep 15
20 views
Consider a finite state transducer (FST) with $Q=\left\{q_{0}, q_{1}\right\}, \Sigma=\{0,1\}, \Gamma=\{a, b$, $\mathrm{c}\}$, initial state $\mathrm{q}_{0}$, and the foll...
1 1 vote
0 0 answers
22
22 views
Shubham Sharma 2 asked Sep 15
22 views
In a memory system with fixed-sized partitions, each holding one process (as in IBM OS$/360$ MFT).Which statement is correct?Multiprogramming limited; internal fragmentat...