What do the letters in the ACID acronym stand for regarding reliable transaction processing in database management systems?
Answer and explanation
Correct answer: A. Atomicity, Consistency, Isolation, Durability
- Step 1: Atomicity ensures all-or-nothing execution; Consistency ensures database rules remain valid. Step 2. Isolation ensures concurrent transactions execute without cross-interference; Durability guarantees committed changes persist through system crashes. Answer: Atomicity, Consistency, Isolation, Durability. Why not the others: The other three options are non-standard combinations not describing database transaction guarantees.
Practise more Computer Systems, Networking and ICT.
Free questions with an explanation for every one, and full timed Bangladesh Civil Service Preliminary Examination mock tests.
More Computer Systems, Networking and ICT questions
- Which internal CPU register holds the memory address of the next machine instruction to be fetched and executed by the processor?
- Which type of computer memory provides the fastest read and write access times directly to the arithmetic logic unit?
- How many distinct memory addresses can be uniquely referenced by a microprocessor with a 32-bit address bus?
- What is the hexadecimal equivalent of the 8-bit binary number 11011010_2?
- Which logic gate outputs a binary 1 if and only if its two binary inputs are unequal (one is 1 and the other is 0)?
- Which two digital logic gates are considered universal gates because any combinational circuit can be constructed solely using either of the…