Courseiva
← FC0-U71
Full test
hardMultiple ChoiceObjective-mapped

FC0-U71 Practice Question: Refer to the exhibit

Exhibit

Refer to the exhibit.

SELECT Customers.CustomerName, Orders.OrderDate
FROM Customers
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE Customers.City = 'New York';

Refer to the exhibit. A database contains tables Customers and Orders. Based on the query, what is the purpose of the INNER JOIN clause?

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

✓

To return only customers who have at least one order in New York

INNER JOIN returns only rows where the CustomerID value matches in both tables. Combined with the WHERE clause filtering orders in New York, the query returns only customers who have placed at least one order in New York. Option B describes a CROSS JOIN. Option C describes a FULL OUTER JOIN. Option D describes a LEFT JOIN.

Answer analysis

Option-by-option breakdown

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

  • ✓

    To return only customers who have at least one order in New York

    Why this is correct

    The INNER JOIN ensures only matching CustomerIDs are returned, filtered by New York.

  • ✗

    To create a Cartesian product of customers and orders

    Why it's wrong here

    That would be a CROSS JOIN without a condition.

  • ✗

    To combine all rows from both tables regardless of match

    Why it's wrong here

    That describes a CROSS JOIN or full outer join.

  • ✗

    To include all customers even if they have no orders

    Why it's wrong here

    That would require a LEFT JOIN.

About these practice questions

One of 988 original FC0-U71 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.