Relational Database Queries - Advanced Basics

Challenge yourself with more fundamental SQL query concepts including subqueries, aggregate functions, string operations, and data manipulation. Perfect for reinforcing your relational database skills.

Elapsed time: 0 Score: 0

START QUIZ!

1/10 Next Question »

Which SQL clause is used to limit the number of rows returned in a query?

TOP

LIMIT

RESTRICT

MAXIMUM

« Prev 2/10 Next Question »

What does the AVG() function do?

Calculates the total sum of values

Finds the middle value

Calculates the average value

Counts non-null values

« Prev 3/10 Next Question »

Which JOIN type returns all rows from both tables, with NULLs where there is no match?

INNER JOIN

CROSS JOIN

LEFT JOIN

FULL OUTER JOIN

« Prev 4/10 Next Question »

What is the purpose of the ORDER BY clause?

To filter rows based on conditions

To sort the result set

To group rows together

To join multiple tables

« Prev 5/10 Next Question »

Which operator is used to search for a pattern in a column?

MATCH

LIKE

SEARCH

FIND

« Prev 6/10 Next Question »

What does the MIN() function return?

The smallest value in a column

The first value in a column

The average of the smallest values

The number of minimum values

« Prev 7/10 Next Question »

Which SQL keyword is used to combine the results of two or more SELECT statements?

MERGE

COMBINE

UNION

APPEND

« Prev 8/10 Next Question »

What does NULL represent in SQL?

An empty string

The value zero

The absence of a value

A false boolean value

« Prev 9/10 Next Question »

Which clause is used to specify which columns to retrieve in a query?

SELECT

FROM

GET

RETRIEVE

« Prev 10/10

What is the result of using CROSS JOIN between two tables?

Only matching rows from both tables

All possible combinations of rows from both tables

All rows from the left table only

Rows that don't match in either table