Courseiva
← CRISC
Full test
easyMultiple ChoiceObjective-mapped

CRISC Practice Question: Based on the exhibit, what risk does this…

Exhibit

Refer to the exhibit.

Exhibit:
```
[2025-03-15 14:23:11] ERROR: Deadlock detected in database 'HR_DB'.
Transaction (ID 4567) was chosen as the victim. Rollback initiated.
Query: UPDATE employees SET salary = ? WHERE dept_id = ?;
```

Based on the exhibit, what risk does this database error MOST directly indicate?

⚠ Common exam trap

It's easy for candidates to confuse a database concurrency error with security vulnerabilities like SQL injection, but the error message and context point to transaction management failures rather than input validation or access control issues.

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

✓

Risk of data inconsistency due to concurrency issues

The database error indicates a concurrency control failure, such as a deadlock or serialization anomaly, which directly leads to data inconsistency when multiple transactions execute simultaneously without proper isolation. This is a classic risk in multi-user database environments where ACID properties are violated, resulting in lost updates or dirty reads.

Answer analysis

Option-by-option breakdown

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

  • ✓

    Risk of data inconsistency due to concurrency issues

    Why this is correct

    Deadlocks can cause partial updates and data inconsistency.

  • ✗

    SQL injection vulnerability

    Why it's wrong here

    Deadlock is not SQL injection.

  • ✗

    Unauthorized access to employee records

    Why it's wrong here

    No evidence of unauthorized access.

  • ✗

    Insufficient disk space for transactions

    Why it's wrong here

    Deadlock is concurrency issue, not storage.

About these practice questions

Courseiva writes every CRISC question from scratch — 983 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This CRISC practice question is part of Courseiva's free ISACA 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 CRISC exam.