Courseiva
← FC0-U71
Full test
easyMultiple ChoiceObjective-mapped

FC0-U71 Practice Question: Refer to the exhibit

Exhibit

Refer to the exhibit.

CREATE TABLE employees (
    employee_id INT PRIMARY KEY,
    first_name VARCHAR(50),
    last_name VARCHAR(50),
    department_id INT,
    hire_date DATE
);

INSERT INTO employees VALUES (1, 'John', 'Doe', 10, '2021-01-15');
INSERT INTO employees VALUES (2, 'Jane', 'Smith', 20, '2020-06-01');
INSERT INTO employees VALUES (3, 'Bob', 'Johnson', 10, '2022-03-22');

Refer to the exhibit. A database administrator executes the following query: SELECT COUNT(*) FROM employees WHERE department_id = 10; What is the result?

⚠ Common exam trap

The FC0-U61 exam often tests the difference between `COUNT(*)`, `COUNT(column)`, and `COUNT(DISTINCT column)`, and the trap here is that candidates might miscount the rows in the exhibit or confuse the filter condition with a different department ID.

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

✓

2

The query `SELECT COUNT(*) FROM employees WHERE department_id = 10;` counts all rows in the `employees` table where the `department_id` column equals 10. According to the exhibit (not shown here but implied), there are exactly two employees in department 10, so the result is 2.

Answer analysis

Option-by-option breakdown

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

  • ✓

    2

    Why this is correct

    Employees with department_id 10 are John Doe and Bob Johnson.

  • ✗

    3

    Why it's wrong here

    3 is the total number of employees, not just those in department 10.

  • ✗

    0

    Why it's wrong here

    There are employees with department_id 10.

  • ✗

    1

    Why it's wrong here

    Only one employee in department 10? Actually there are two.

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 →

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.