Basic Relational Database Queries Quiz

Test your knowledge of fundamental SQL queries and relational database concepts. This quiz covers SELECT statements, JOIN operations, filtering, aggregation, and other essential database query skills.

Elapsed time: 0 Score: 0

START QUIZ!

1/10 Next Question »

Which SQL clause is used to filter rows based on a condition?

HAVING

WHERE

FILTER

SELECT

« Prev 2/10 Next Question »

What does the INNER JOIN operation return?

All rows from the left table

All rows from both tables

Only rows with matching values in both tables

All rows from the right table

« Prev 3/10 Next Question »

Which SQL function is used to count the number of rows in a result set?

SUM()

TOTAL()

COUNT()

NUMBER()

« Prev 4/10 Next Question »

What is the purpose of the GROUP BY clause?

To sort the result set

To group rows with the same values for aggregation

To filter rows after aggregation

To join multiple tables

« Prev 5/10 Next Question »

Which keyword is used to sort query results in descending order?

DOWN

DESCENDING

REVERSE

DESC

« Prev 6/10 Next Question »

What does the DISTINCT keyword do in a SELECT statement?

Removes duplicate rows from the result

Sorts the results alphabetically

Counts unique values

Filters null values

« Prev 7/10 Next Question »

Which clause is used to filter groups after aggregation?

WHERE

FILTER

HAVING

GROUP_FILTER

« Prev 8/10 Next Question »

What is the result of a LEFT JOIN when there is no match in the right table?

The row is excluded from the result

An error is returned

The row is included with NULL values for right table columns

The row is duplicated

« Prev 9/10 Next Question »

Which SQL operator is used to check if a value matches any value in a list?

BETWEEN

LIKE

IN

ANY

« Prev 10/10

What does the SQL wildcard '%' represent in a LIKE clause?

Exactly one character

Zero or more characters

A space character

Any numeric value