SQL Query Writing Fundamentals Quiz

1. What does LEFT JOIN return?

All rows from the left table and matching rows from the right

Only matching rows from both tables

All rows from both tables

Only rows from the left table

2. What does a foreign key establish between tables?

A sorting order

A relationship or link

A backup copy

A data type constraint

3. Which SQL keyword prevents duplicate values in aggregate results?

UNIQUE

DISTINCT

SINGLE

EXCLUDE

Submit

5. What is the primary key used for?

To store encrypted data

To uniquely identify each record in a table

To sort rows automatically

To link tables together

6. Which operator is used to search for patterns in SQL?

LIKE

MATCH

SEARCH

FIND

Submit

8. What does the AVG() function calculate?

The sum of values

The average of numeric values

The maximum value

The minimum value

9. Which SQL statement removes records from a table?

REMOVE

DELETE

DROP

ERASE

Submit

11. Which SQL keyword is used to retrieve data from a database table?

SELECT

RETRIEVE

FETCH

GET

12. Which clause is used to group rows with aggregate functions?

ORDER BY

WHERE

GROUP BY

HAVING

Submit

14. What is the purpose of the DISTINCT keyword?

Removes duplicate rows from results

Sorts results in reverse order

Filters rows with null values

Groups results by column

15. Which SQL function counts the number of rows?

SUM()

COUNT()

TOTAL()

NUMBER()

Submit

17. In SQL, what does INNER JOIN do?

Returns all rows from both tables

Returns only matching rows from both tables

Returns all rows from the left table

Returns all rows from the right table

18. Which SQL clause is used to sort query results?

FILTER

ORDER BY

SORT

ARRANGE

Submit

20. What does the WHERE clause do in a SQL query?

Sorts the results in ascending order

Filters records based on specified conditions

Limits the number of rows returned

Groups results by a column

General Databases Beginner Basic SQL Query Writing Quiz

1. What does LEFT JOIN return?

2.

What first name or nickname would you like us to use?

2. What does a foreign key establish between tables?

3. Which SQL keyword prevents duplicate values in aggregate results?

4. Complete: SELECT name FROM students _____ department = 'Engineering'

5. What is the primary key used for?

6. Which operator is used to search for patterns in SQL?

7. Write the SQL keyword to modify existing records: _____ table_name

8. What does the AVG() function calculate?

9. Which SQL statement removes records from a table?

10. Complete: UPDATE employees _____ salary = 60000 WHERE id = 5

11. Which SQL keyword is used to retrieve data from a database table?

12. Which clause is used to group rows with aggregate functions?

13. Write the SQL keyword to add new records to a table: _____ INTO table_name

14. What is the purpose of the DISTINCT keyword?

15. Which SQL function counts the number of rows?

16. Complete the statement: SELECT * FROM employees WHERE salary > 50000 _____ age;

17. In SQL, what does INNER JOIN do?

18. Which SQL clause is used to sort query results?

19. Write the SQL keyword that selects all columns: SELECT _____ FROM table_name

20. What does the WHERE clause do in a SQL query?