← All IKM Flashcard Decks

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
  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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 , 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

  1. ikmnet.com — Test delivery, passing score · verified Oct 2026
  2. online.ikmnet.com — Eligibility, exam format, retake policy, score release, time limit · verified Oct 2026