SQL Programming Beginner Quiz 4
q
L
quizLearn
Select your answers and check your results. Use Reset to start again.
Practice Pronunciation (Merriam-Webster)
Search Google
Search
Navigation
Python Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Python Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Python Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
SQL Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
SQL Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
SQL Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
JavaScript Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
JavaScript Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
JavaScript Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C# Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C# Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C# Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Java Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Java Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
Java Advanced Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C Beginner Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C Intermediate Quizzes
Quiz 1,
Quiz 2,
Quiz 3,
Quiz 4,
Quiz 5
C 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