Courseiva
← FC0-U71
Full test
mediumMultiple ChoiceObjective-mapped

FC0-U71 Practice Question: A developer writes a query: SELECT * FROM…

A developer writes a query: SELECT * FROM Employees WHERE Department = 'Sales'. Which statement about this query is true?

⚠ Common exam trap

It's easy for candidates to confuse the SELECT clause with the WHERE clause, mistakenly thinking SELECT * returns all rows (option D) or only a specific column (option C), when in fact SELECT * returns all columns and WHERE filters rows.

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

✓

It returns all columns for employees in Sales

The SELECT * clause retrieves all columns from the specified table, and the WHERE Department = 'Sales' filter restricts the result set to only those rows where the Department column has the value 'Sales'. Therefore, the query returns every column for employees in the Sales department, making option B correct.

Answer analysis

Option-by-option breakdown

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

  • ✗

    It sorts results by Department

    Why it's wrong here

    There is no ORDER BY clause, so results are not sorted.

  • ✓

    It returns all columns for employees in Sales

    Why this is correct

    SELECT * returns all columns, and the WHERE clause filters for Sales department.

  • ✗

    It returns only the Department column

    Why it's wrong here

    SELECT * returns all columns, not just Department.

  • ✗

    It returns all rows from the Employees table

    Why it's wrong here

    The WHERE clause filters only rows where Department is 'Sales', so not all rows are returned.

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.