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
ORDER BY
WHERE
GROUP BY
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 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
INNER JOIN
RIGHT JOIN
CROSS JOIN
LEFT JOIN
Q5. Which clause is used to sort results?
Select one answer • 1 pt
ORDER BY
SORT BY
GROUP BY
ARRANGE
Q6. Which statement adds a new row to a table?
Select one answer • 1 pt
UPDATE
INSERT INTO
ADD ROW
APPEND
Q7. What is the purpose of GROUP BY?
Select one answer • 1 pt
To rename columns in results
To filter rows before SELECT
To group rows for aggregate calculations
To sort rows alphabetically
Q8. Which clause filters groups after GROUP BY?
Select one answer • 1 pt
HAVING
LIMIT
WHERE
FROM
Q9. Which keyword limits the number of rows returned in MySQL?
Select one answer • 1 pt
TAKE
TOP
LIMIT
FETCH
Q10. What does an INNER JOIN return?
Select one answer • 1 pt
No rows unless NULLs exist
All rows from the left table
All rows from both tables regardless of match
Only matching rows from both tables
Cancel
Submit answers