SQL Programming Beginner Quiz 4
Select your answers and check your results. Use Reset to start again.
Search
Practice Pronunciation (Merriam-Webster)
Navigation
Python Programming Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Python Programming Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Python Programming Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
SQL Programming Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
SQL Programming Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
SQL Programming Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
JavaScript Programming Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
JavaScript Programming Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
JavaScript Programming Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C# Programming Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C# Programming Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C# Programming Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Java Programming Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Java Programming Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Java Programming Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C Programming Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C Programming Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C Programming Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Beginner Quiz 4
1. How do you select all records where "status" is not "active"?
WHERE status <> 'active'
WHERE status != 'active'
WHERE status NOT 'active'
2. Which SQL clause limits the number of returned rows?
LIMIT
ROWS
COUNT
3. Which SQL function returns the smallest value?
MIN()
LOWEST()
BOTTOM()
4. How do you select only unique values in a column?
SELECT DISTINCT column FROM table;
SELECT UNIQUE column FROM table;
SELECT column FROM table GROUP BY column;
5. Which SQL statement is used to remove specific rows?
DELETE FROM table WHERE ...;
DROP FROM table WHERE ...;
REMOVE FROM table WHERE ...;
6. How do you select all columns from "products" where price is over 100?
SELECT * FROM products WHERE price > 100;
SELECT price FROM products WHERE price > 100;
SELECT * FROM products WHERE price >= 100;
7. Which SQL statement adds a new column "email" to "users"?
ALTER TABLE users ADD email VARCHAR(255);
ADD COLUMN email TO users;
UPDATE users ADD email;
8. How do you remove duplicate rows from results?
SELECT DISTINCT ...
SELECT UNIQUE ...
SELECT REMOVE DUPLICATES ...
9. Which SQL clause is used after GROUP BY to filter groups?
HAVING
WHERE
FILTER
10. How do you select all records where "age" is NULL?
WHERE age IS NULL
WHERE age = NULL
WHERE age == NULL
Previous
Check Quiz
Reset
Next
Other
Timer
00:00
Start
Stop
Reset
Vocabulary Quiz
Score: 0
Reset Score
Submit Answer
Next Word
Spin the Wheel
SPIN
Promo's
Explore More
SQL Documentation
SQL Tutorials