Beginner ~12 min

SQL Basics

Core SQL fundamentals: SELECT, WHERE, JOIN, GROUP BY, and aggregates.

Progress: 0/10

Beginner • ~12 min

Q1. Which SQL clause is used to filter rows returned by a SELECT query?

Select one answer • 1 pt

ORDER BY GROUP BY WHERE HAVING

Q2. Which keyword returns only unique rows?

Select one answer • 1 pt

ONLY SINGLE DISTINCT UNIQUE

Q3. What does COUNT(*) return?

Select one answer • 1 pt

The sum of all numeric columns The number of tables in the database The number of non-NULL values in a column The number of rows returned

Q4. Which JOIN returns all rows from the left table and matching rows from the right table?

Select one answer • 1 pt

CROSS JOIN LEFT JOIN RIGHT JOIN INNER JOIN

Q5. Which clause is used to sort results?

Select one answer • 1 pt

ORDER BY ARRANGE GROUP BY SORT BY

Q6. Which statement adds a new row to a table?

Select one answer • 1 pt

ADD ROW INSERT INTO UPDATE APPEND

Q7. What is the purpose of GROUP BY?

Select one answer • 1 pt

To filter rows before SELECT To rename columns in results To sort rows alphabetically To group rows for aggregate calculations

Q8. Which clause filters groups after GROUP BY?

Select one answer • 1 pt

WHERE LIMIT FROM HAVING

Q9. Which keyword limits the number of rows returned in MySQL?

Select one answer • 1 pt

LIMIT TAKE FETCH TOP

Q10. What does an INNER JOIN return?

Select one answer • 1 pt

All rows from the left table Only matching rows from both tables All rows from both tables regardless of match No rows unless NULLs exist

Cancel