Beginner SQL Quiz

1 / 10

Which SQL statement is used to retrieve data from a database?

FETCH

GET

RETRIEVE

SELECT

2 / 10

What does the WHERE clause do in SQL?

Sorts the result set

Joins two tables

Limits the number of rows returned

Filters rows based on a condition

3 / 10

Which keyword is used to sort the result set in SQL?

SORT

GROUP BY

ORDER BY

ARRANGE

4 / 10

What is the purpose of the JOIN clause in SQL?

To update existing data

To combine rows from two or more tables

To delete rows from a table

To create a new table

5 / 10

What SQL function returns the number of rows in a table?

SUM()

TOTAL()

NUMBER()

COUNT()

6 / 10

Which clause is used to group rows sharing a common value?

JOIN

WHERE

GROUP BY

ORDER BY

7 / 10

Which SQL keyword is used to remove duplicate rows from a result set?

REMOVE

FILTER

DISTINCT

UNIQUE

8 / 10

What does the INSERT INTO statement do?

Adds new data

Retrieves data

Deletes data

Updates data

9 / 10

Which clause limits the number of rows returned?

LIMIT

MAX

ROWNUM

TOP

10 / 10

Which SQL statement is used to modify existing data?

CHANGE

UPDATE

MODIFY

ALTER

Your score is

The average score is 79%

0%