FC0-U71 Data and Database Fundamentals Practice Question
Which SQL statement would you use to retrieve the names of all products with a price greater than $50 from a table named 'Products'?
⚠ Common exam trap
FC0-U71 often tests the WHERE vs. HAVING distinction and the correct SQL keyword set — candidates who confuse filtering clauses or invent non-SQL keywords like GET or IF pick the wrong answer.
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 Name FROM Products WHERE Price > 50
The correct SQL syntax to filter rows is SELECT ... FROM ... WHERE condition. Option A retrieves the Name column from Products where Price exceeds 50, which is exactly the requested query. WHERE is the standard clause for row-level filtering in a SELECT statement, and the comparison operator > correctly expresses 'greater than.'
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 Name FROM Products WHERE Price > 50
Why this is correct
SELECT retrieves only the Name column, satisfying the requirement to return product names alone, while WHERE filters rows using the Price > 50 predicate. This precisely matches the stem's constraints: table Products, names only, price threshold above $50.
- ✗
SELECT Name FROM Products HAVING Price > 50
Why it's wrong here
HAVING filters aggregated groups produced by GROUP BY, so without grouping it is invalid here; WHERE filters individual rows before aggregation. It is tempting because HAVING does restrict results, but it applies to aggregate output, not to a simple per-row price condition on Products.
- ✗
SELECT * FROM Products IF Price > 50
Why it's wrong here
IF is not a SQL clause; row filtering uses WHERE. It is tempting because IF reads like conditional logic in procedural languages, but standard SQL has no IF keyword in SELECT syntax, so the statement fails to parse rather than returning the product names requested.
- ✗
GET Name FROM Products WHERE Price > 50
Why it's wrong here
GET is not a SQL keyword; retrieval requires SELECT. The syntax otherwise mirrors a valid query, which is what makes it tempting, but no SQL dialect accepts GET as a statement verb. SELECT Name FROM Products WHERE Price > 50 is the working form.
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 →
Same concept, more angles
4 more ways 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. Which of the following is a valid SQL statement to retrieve all records from a table named 'Employees'?
easy- A.GET * FROM Employees
- ✓ B.SELECT * FROM Employees
- C.FETCH * FROM Employees
- D.READ * FROM Employees
Why B: The correct SQL statement to retrieve all records from a table named 'Employees' is SELECT * FROM Employees. The SELECT clause specifies the columns to return, and the asterisk (*) is a wildcard meaning all columns. The FROM clause specifies the table to query. This is standard SQL syntax defined by ANSI/ISO and supported by all major relational database management systems (RDBMS) such as MySQL, PostgreSQL, SQL Server, and Oracle.
Variation 2. A user needs to retrieve all product names and prices from a table named 'Products' where the price is greater than 50. Which SQL statement should be used?
medium- ✓ A.SELECT name, price FROM Products WHERE price > 50;
- B.GET name, price FROM Products WHERE price > 50;
- C.SELECT name, price FROM Products;
- D.SELECT * FROM Products WHERE price > 50;
Why A: The correct SQL statement must select the columns 'name' and 'price' from the 'Products' table and filter rows where 'price' is greater than 50. Option A does exactly this with proper SELECT, FROM, and WHERE clauses. It retrieves only the required columns and applies the correct condition.
Variation 3. Which SQL statement is used to retrieve all columns from a table named 'Customers' where the city is 'London'?
easy- ✓ A.SELECT * FROM Customers WHERE city = 'London';
- B.RETRIEVE * FROM Customers WHERE city = 'London';
- C.SELECT * FROM Customers HAVING city = 'London';
- D.GET * FROM Customers WHERE city = 'London';
Why A: 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.
Variation 4. Which SQL statement is used to retrieve all columns from a table named 'Employees'?
easy- ✓ A.SELECT * FROM Employees
- B.RETRIEVE Employees
- C.SHOW * FROM Employees
- D.GET * FROM Employees
Why A: SELECT * FROM Employees is the correct SQL statement to retrieve all columns from the Employees table. SELECT * specifies all columns, and FROM identifies the table. No WHERE clause is needed because the question asks for all rows.
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.