Courseiva
← FC0-U71
Full test
mediumMultiple ChoiceObjective-mapped

FC0-U71 Practice Question: A database administrator needs to ensure that a…

A database administrator needs to ensure that a transaction either fully completes or is fully rolled back. Which database property guarantees this?

⚠ Common exam trap

Candidates often confuse atomicity with consistency, mistakenly thinking that 'all or nothing' is about maintaining data rules, when in fact atomicity is the specific property that guarantees transactional indivisibility.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Atomicity

Atomicity ensures that a transaction is treated as a single, indivisible unit of work: either all of its operations are committed successfully, or none are applied, and the database is rolled back to its previous state. This property directly guarantees the 'all or nothing' behavior required by the database administrator. In SQL databases, atomicity is typically enforced through transaction control statements like BEGIN TRANSACTION, COMMIT, and ROLLBACK, with the database engine managing undo logs to reverse partial changes if a failure occurs.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Isolation

    Why it's wrong here

    Isolation ensures that concurrent transactions do not interfere with each other.

  • ✗

    Durability

    Why it's wrong here

    Durability ensures that once a transaction is committed, it remains so even after a system failure.

  • ✓

    Atomicity

    Why this is correct

    Atomicity ensures that each transaction is 'all or nothing'.

  • ✗

    Consistency

    Why it's wrong here

    Consistency ensures that a transaction brings the database from one valid state to another.

About these practice questions

One of 988 original FC0-U71 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

1 more way this is tested on FC0-U71

These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.

Variation 1. A database administrator notices that a transaction that updates two tables is failing halfway, leaving data inconsistent. Which property of ACID ensures that the database returns to its original state if the transaction fails?

hard
  • A.Consistency
  • B.Durability
  • C.Isolation
  • ✓ D.Atomicity

Why D: Atomicity (option D) ensures that a transaction is treated as a single, indivisible unit of work. If any part of the transaction fails (e.g., updating the second table), the entire transaction is rolled back, and the database returns to its original state before the transaction began. This prevents partial updates that would leave data inconsistent.

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This FC0-U71 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the FC0-U71 exam.