Courseiva
← FC0-U71
Full test
easyMultiple ChoiceObjective-mapped

FC0-U71 Practice Question: Refer to the exhibit

Exhibit

Refer to the exhibit.

CREATE TABLE Products (
  ProductID INT PRIMARY KEY,
  ProductName VARCHAR(50),
  Price DECIMAL(10,2)
);

INSERT INTO Products VALUES (1, 'Laptop', 999.99);
INSERT INTO Products VALUES (2, 'Mouse', 25.50);

Refer to the exhibit. The Products table has been created and two rows have been inserted. What will be the result of the following query? SELECT ProductName FROM Products WHERE Price > 100;

⚠ Common exam trap

CompTIA often tests the candidate's ability to apply a simple numeric comparison in a WHERE clause, and the trap here is assuming that all rows are returned or misreading the exhibit's data, leading to selecting 'Mouse' or both products.

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

✓

Laptop

The query selects ProductName from the Products table where the Price column is greater than 100. According to the exhibit (not shown but implied), only the row with ProductName 'Laptop' has a Price value exceeding 100, so only 'Laptop' is returned. This demonstrates the basic SQL WHERE clause filtering on a numeric column.

Answer analysis

Option-by-option breakdown

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

  • ✗

    Mouse

    Why it's wrong here

    Mouse price is 25.50, not greater than 100.

  • ✗

    Laptop, Mouse

    Why it's wrong here

    Mouse does not meet the condition.

  • ✓

    Laptop

    Why this is correct

    Laptop meets the condition Price > 100.

  • ✗

    An empty result set

    Why it's wrong here

    Laptop satisfies the condition, so not empty.

About these practice questions

This FC0-U71 question is part of Courseiva's 988-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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 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.