FC0-U71 Data and Database Fundamentals Practice Question
Which SQL statement is used to retrieve all columns from a table named 'Customers' where the city is 'London'?
⚠ Common exam trap
FC0-U71 often tests the difference between WHERE and HAVING, and candidates mistakenly choose HAVING for filtering on a regular column, forgetting that HAVING is for aggregate filters after GROUP BY.
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
✓
SELECT * FROM Customers WHERE city = 'London';
SELECT * FROM Customers WHERE city = 'London'; is the correct SQL statement to retrieve all columns from the Customers table where the city is London. SELECT * specifies all columns, FROM identifies the table, and WHERE filters rows based on the city condition. The semicolon terminates the statement.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
SELECT * FROM Customers WHERE city = 'London';
Why this is correct
SELECT * retrieves every column, FROM Customers names the source table, and the WHERE clause filters rows where city equals 'London'. The asterisk wildcard expands to all columns, satisfying the requirement to return complete rows matching the specified city condition.
- ✗
RETRIEVE * FROM Customers WHERE city = 'London';
Why it's wrong here
RETRIEVE is not a SQL keyword; the statement fails to parse. It is tempting because it reads as a natural synonym for fetching rows; the correct verb is SELECT, which is the standard clause for projecting columns, so RETRIEVE would only be right in a non-SQL query language that defines it.
- ✗
SELECT * FROM Customers HAVING city = 'London';
Why it's wrong here
HAVING filters aggregated groups produced by GROUP BY, not individual rows, so it cannot restrict city values here. It is tempting because it looks like WHERE, and it would be correct after aggregating, for example HAVING count(*) > 5.
- ✗
GET * FROM Customers WHERE city = 'London';
Why it's wrong here
GET is not a SQL statement; no such keyword exists in the language. It is tempting because GET resembles HTTP or PowerShell retrieval verbs, and in those contexts it does fetch data, but SQL requires SELECT to project columns from Customers.
About these practice questions
Courseiva writes every FC0-U71 question from scratch — 988 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 →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
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.