SQL Database Fundamentals

By Devin Park · Updated May 25, 2026

Questions25
Passing Score70%
Format64% Multiple Choice
Sessions Logged1,586
Your progressLog in / Register to track times taken, best score, questions mastered, and coverage on this quiz.
Rating
4.7 (25)

Topics covered

This quiz

Uncategorized25 (100%)

Uncategorized25 questions

Browse more · Report this quiz

Question catalog for this preview

Catalog listing of the 5 preview questions for this quiz.

Question 1

What type of JOIN returns only rows where there is a match in BOTH tables?

Answer choices

  • A. LEFT JOIN

  • B. RIGHT JOIN

  • C. FULL OUTER JOIN

  • D. INNER JOIN

Question 2

What does the following query do?

```sql

SELECT department, COUNT(*) as employee_count

FROM employees

GROUP BY department

HAVING COUNT(*) > 5;

```

Answer choices

  • A. Selects all employees in departments with more than 5 total employees in the company

  • B. Counts employees per department and shows only departments that have more than 5 employees

  • C. Deletes departments with fewer than 5 employees

  • D. Selects the top 5 employees from each department

Question 3

Place the SQL clauses in the correct logical execution order (the order the database engine processes them, not how they appear in the query):

Answer choices

  • A. ORDER BY

  • B. FROM / JOIN

  • C. HAVING

  • D. SELECT

  • E. WHERE

Question 4

Which of the following are SQL aggregate functions? (Select ALL that apply)

Answer choices

  • A. COUNT()

  • B. SUM()

  • C. AVG()

  • D. CONCAT()

  • E. MAX()

Question 5

What does the SQL `DISTINCT` keyword do?

Answer choices

  • A. Sorts results in descending order

  • B. Removes duplicate rows from the result set

  • C. Returns only the first distinct column

  • D. Filters NULL values from results