Intermediate SQL Quiz

1 / 10

Which function returns the highest value in a column?

MIN()

MAX()

MOST()

COUNT()

2 / 10

Which function calculates the average of numeric values?

MAX()

MEAN()

COUNT()

AVG()

3 / 10

Which function returns the number of rows in a result set?

SUM()

NUMROWS()

MAX()

COUNT()

4 / 10

What type of JOIN returns only matching rows from both tables?

RIGHT JOIN

LEFT JOIN

FULL OUTER JOIN

INNER JOIN

5 / 10

Which keyword is used to reference a column from an outer query inside a subquery?

CORRELATED

EXISTS

OUTER

PARENT

6 / 10

Which JOIN includes all rows from the left table and matched rows from the right?

LEFT JOIN

FULL JOIN

RIGHT JOIN

INNER JOIN

7 / 10

Which SQL clause is commonly used to filter results from a subquery?

WHERE

HAVING

GROUP BY

IN

8 / 10

Which clause is used to combine rows from two or more tables based on a related column?

HAVING

ORDER BY

JOIN

GROUP BY

9 / 10

What does a subquery in the SELECT clause typically return?

A single value

A column name

Multiple rows

A table

10 / 10

What is the primary purpose of a Common Table Expression (CTE) in SQL?

To permanently store query results in a new table

To define a temporary result set for use within a larger quer

To enforce referential integrity between tables

To optimize indexes for faster joins

Your score is

The average score is 70%

0%