What does the Consistency property in ACID guarantee during a bank fund transfer transaction? You are designing the schema for a Savings_Accounts…
What does the Consistency property in ACID guarantee during a bank fund transfer transaction? You are designing the schema for a Savings_Accounts table. Write the specific SQL constraint clause to ensure that the current_balance column can never drop below zero.
From the Combined Bank Assistant Maintenance Engineer (IT) May 2026 – Written exam, question 4 of 13.
More from this paper
- Previous: At which layer of the OSI model does a standard Router primarily operate, and what is the specific name of the Protocol Data Unit (PDU) at…
- Next: Briefly explain "Circular Wait." In a Resource Allocation Graph (RAG), if a cycle exists, does it absolutely guarantee that a Deadlock has…
- All questions in Combined Bank Assistant Maintenance Engineer (IT) May 2026 – Written