SQL Query Language Flashcards
6 cards from real IKM practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 SQL Query Language flashcards as text
Which SQL clause is used to filter groups produced by GROUP BY?
Answer: HAVING
HAVING filters after aggregation and can use aggregate functions such as COUNT(*) > 5. WHERE filters individual rows before they are grouped.
Which join returns all rows from the left table and matching rows from the right table, with NULLs where there is no match?
Answer: LEFT JOIN
A LEFT (OUTER) JOIN keeps every row of the left table. Right-side columns are NULL when no matching row exists.
What is the result of `SELECT COUNT(column_name)` compared to `SELECT COUNT(*)` when column_name contains NULLs?
Answer: COUNT(column_name) ignores NULL values; COUNT(*) counts all rows
COUNT(*) counts every row. COUNT(column) counts only the rows where that column is not NULL.
Which statement removes all rows that match a condition from a table, while keeping the table itself?
Answer: DELETE FROM ... WHERE ...
DELETE FROM with a WHERE clause removes the matching rows and leaves the table structure in place. DROP TABLE removes the table itself.
How do you correctly test whether a column's value is missing in SQL?
Answer: WHERE col IS NULL
NULL represents an unknown value, so comparisons with = evaluate to unknown rather than true. IS NULL is the correct test.
What does the keyword DISTINCT do in `SELECT DISTINCT city FROM customers`?
Answer: Returns only unique city values
DISTINCT removes duplicate rows from the result set. The stored data in the table is not changed.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- ikmnet.com — Test delivery, passing score · verified Oct 2026
- online.ikmnet.com — Eligibility, exam format, retake policy, score release, time limit · verified Oct 2026