Quick Answer
The answer is that the table 'Employees' is empty. This is the most likely reason because an UPDATE statement in SQL modifies existing rows; when a table contains no records, the database engine correctly executes the command but finds nothing to change, resulting in the message '0 rows affected' regardless of the SET or WHERE clause used. On the CompTIA ITF+ FC0-U61 exam, this scenario tests your understanding that a successful SQL execution does not guarantee data was modified—a common trap is assuming a syntax error occurred when you see zero rows affected. Remember that '0 rows affected' simply means the statement parsed and ran without error, but no target data existed. A helpful memory tip: "No rows to update means zero to affect—check the table, not the syntax."
This FC0-U61 practice question tests your understanding of database fundamentals. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
UPDATE Employees SET Salary = Salary + 500;
Refer to the exhibit. The following SQL statement is executed. The result message is: '0 rows affected'. What is the most likely reason?
Clue words in this question
Noticing these words before you look at the options changes how you read each choice.
Clue: "most likely"
Why it matters: Probability qualifier — the question wants the most probable cause or outcome, not a guaranteed one. Eliminate low-probability options.
UPDATE Employees SET Salary = Salary + 500;
The table 'Employees' does not exist
Why wrong: Would cause an error message.
The UPDATE privilege has been revoked
Why wrong: Would result in a permission error.
The table 'Employees' is empty
No rows to update.
The statement lacks a WHERE clause
Why wrong: Lacking WHERE is valid and updates all rows.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
The table 'Employees' is empty
The SQL statement executed successfully (no syntax error) but affected zero rows because the target table 'Employees' is empty. An UPDATE statement modifies existing rows; if no rows exist, zero rows are affected regardless of the SET or WHERE clause. The message '0 rows affected' indicates the statement parsed and executed without error, but no data matched the condition (or there was no data to update).
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
The table 'Employees' does not exist
Why it's wrong here
Would cause an error message.
The UPDATE privilege has been revoked
Why it's wrong here
Would result in a permission error.
The table 'Employees' is empty
Why this is correct
No rows to update.
Clue confirmation
The clue word "most likely" in the question point toward this answer.
Related concept
Read the scenario before looking for a memorised answer.
The statement lacks a WHERE clause
Why it's wrong here
Lacking WHERE is valid and updates all rows.
Common exam traps
CompTIA often tests the distinction between a successful but zero-row operation and an error condition, trapping candidates who assume '0 rows affected' implies a missing WHERE clause or a nonexistent table.
Detailed technical explanation
In SQL, the UPDATE statement first identifies the set of rows to modify based on the WHERE clause (or all rows if omitted). If the table is empty, the row set is empty, and the operation affects zero rows. This is distinct from a syntax error or privilege failure, which would produce an error message. Real-world scenarios often involve empty tables after a TRUNCATE or initial creation before data insertion, leading to this exact behavior.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A junior network technician can log in to a core router but cannot reach the enable prompt or configuration mode. The AAA server is authenticating the login — but the authorisation policy only grants privilege level 1, not 15. Authentication (who you are) is working; authorisation (what you can do) is not.
What to study next
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Database Fundamentals — study guide chapter
Learn the concepts, then practise the questions
Database Fundamentals practice questions
Targeted practice on this topic area only
All FC0-U61 questions
512 questions across all exam domains
CompTIA ITF+ FC0-U61 study guide
Full concept coverage aligned to exam objectives
FC0-U61 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise FC0-U61 questions linked to IT Concepts and Terminology.
Practise FC0-U61 questions linked to Infrastructure.
Practise FC0-U61 questions linked to Applications and Software.
Practise FC0-U61 questions linked to Software Development Concepts.
Practise FC0-U61 questions linked to Security.
Practise FC0-U61 questions linked to Database Fundamentals.
Practise FC0-U61 questions linked to FC0-U61 fundamentals.
Practise FC0-U61 questions linked to FC0-U61 scenario.
Practise FC0-U61 questions linked to FC0-U61 troubleshooting.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Database Fundamentals — This question tests Database Fundamentals — Read the scenario before looking for a memorised answer..
The correct answer is: The table 'Employees' is empty — The SQL statement executed successfully (no syntax error) but affected zero rows because the target table 'Employees' is empty. An UPDATE statement modifies existing rows; if no rows exist, zero rows are affected regardless of the SET or WHERE clause. The message '0 rows affected' indicates the statement parsed and executed without error, but no data matched the condition (or there was no data to update).
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Yes — watch for: "most likely". Probability qualifier — the question wants the most probable cause or outcome, not a guaranteed one. Eliminate low-probability options.
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 30, 2026
This FC0-U61 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-U61 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.