IPA IP 2022 Question 77

A question IPA Japan published in 令和4年度 ITパスポート試験公開問題問77, translated into English. ITPEC is based on the same exams.

Which of the following is an appropriate description concerning the ACID properties of transaction processing?

a)By preparing an index, the search speed when data is searched can be increased.b)By controlling so that a series of processes is either all executed or not executed at all when data is updated, atomicity can be ensured.c)By distributing copies of the database to multiple servers, availability can be increased.d)By normalizing tables, inconsistency and duplication of data can be prevented.

Explanation

All of a series of updates, or none of it, ensures atomicity — atomicity is the A of the ACID properties.

The ACID properties of a transaction:

•Atomicity: the transaction is completed entirely (commit) or not at all (rollback)
•Consistency: the database moves from one valid state to another
•Isolation: concurrent transactions do not interfere with each other's results
•Durability: committed results survive a failure

Answer (b)

Why not others:

•(a) — an index speeds up searches; it is a performance measure, not a transaction property
•(c) — replication raises availability, a property of the system, not one of the four ACID properties
•(d) — normalisation removes redundancy in the table design; it is done at design time, not by transaction control

Key rule: ACID is Atomicity, Consistency, Isolation and Durability; indexes, replication and normalisation are database techniques outside it.

Databases · AI-written, may contain errors

Previous Next

Practice this exam

This question comes from the past questions IPA Japan publishes, translated into English by ITPEC Practice. ITPEC Practice is an independent study tool and is not affiliated with IPA or ITPEC. See the original paper (PDF) or Report an issue.