Categories
Tests
Leaderboards
Projects
About
Arcade
Hello, Guest
Login
Categories
Tests
Leaderboards
Projects
About
Arcade
Login
← Back to Programming & Development
Beginner
~12 min
SQL Basics
Core SQL fundamentals: SELECT, WHERE, JOIN, GROUP BY, and aggregates.
View leaderboard
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
HAVING
GROUP BY
WHERE
ORDER BY
Q2. Which keyword returns only unique rows?
Select one answer • 1 pt
DISTINCT
SINGLE
UNIQUE
ONLY
Q3. What does COUNT(*) return?
Select one answer • 1 pt
The number of non-NULL values in a column
The sum of all numeric columns
The number of rows returned
The number of tables in the database
Q4. Which JOIN returns all rows from the left table and matching rows from the right table?
Select one answer • 1 pt
CROSS JOIN
RIGHT JOIN
INNER JOIN
LEFT JOIN
Q5. Which clause is used to sort results?
Select one answer • 1 pt
ARRANGE
GROUP BY
ORDER BY
SORT BY
Q6. Which statement adds a new row to a table?
Select one answer • 1 pt
ADD ROW
APPEND
INSERT INTO
UPDATE
Q7. What is the purpose of GROUP BY?
Select one answer • 1 pt
To sort rows alphabetically
To group rows for aggregate calculations
To filter rows before SELECT
To rename columns in results
Q8. Which clause filters groups after GROUP BY?
Select one answer • 1 pt
FROM
HAVING
WHERE
LIMIT
Q9. Which keyword limits the number of rows returned in MySQL?
Select one answer • 1 pt
TOP
LIMIT
TAKE
FETCH
Q10. What does an INNER JOIN return?
Select one answer • 1 pt
Only matching rows from both tables
All rows from the left table
All rows from both tables regardless of match
No rows unless NULLs exist
Cancel
Submit answers