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
GROUP BY
WHERE
ORDER BY
HAVING
Q2. Which keyword returns only unique rows?
Select one answer • 1 pt
ONLY
UNIQUE
DISTINCT
SINGLE
Q3. What does COUNT(*) return?
Select one answer • 1 pt
The sum of all numeric columns
The number of rows returned
The number of non-NULL values in a column
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
LEFT JOIN
INNER JOIN
RIGHT JOIN
Q5. Which clause is used to sort results?
Select one answer • 1 pt
ARRANGE
GROUP BY
SORT BY
ORDER BY
Q6. Which statement adds a new row to a table?
Select one answer • 1 pt
ADD ROW
UPDATE
APPEND
INSERT INTO
Q7. What is the purpose of GROUP BY?
Select one answer • 1 pt
To rename columns in results
To filter rows before SELECT
To sort rows alphabetically
To group rows for aggregate calculations
Q8. Which clause filters groups after GROUP BY?
Select one answer • 1 pt
FROM
WHERE
HAVING
LIMIT
Q9. Which keyword limits the number of rows returned in MySQL?
Select one answer • 1 pt
TOP
TAKE
LIMIT
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
No rows unless NULLs exist
All rows from both tables regardless of match
Cancel
Submit answers