CompTIA Data+ (DA0-001) — Question 284

Which of the following query statements would be used when filtering data in a relational database management system? (Choose two.)

Answer options

• A. ORDER BY
• B. HAVING
• C. WHERE
• D. SELECT
• E. INSERT
• F. GROUP BY

Correct answer: B, C

Explanation

The correct answers are HAVING and WHERE because both are used to filter records based on specific conditions in a SQL query. ORDER BY is used for sorting results, SELECT retrieves data, INSERT adds new records, and GROUP BY organizes data into groups, but does not filter it.