SQL Programming Beginner Quiz 3
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 3
1. How do you select records where "salary" is between 3000 and 5000?
WHERE salary BETWEEN 3000 AND 5000
WHERE salary >= 3000 AND salary <= 5000
WHERE salary IN (3000, 5000)
2. Which SQL keyword is used to combine rows from two tables?
JOIN
MERGE
APPEND
3. How do you select unique job titles from "jobs"?
SELECT DISTINCT title FROM jobs;
SELECT UNIQUE title FROM jobs;
SELECT title FROM jobs GROUP BY title;
4. Which SQL clause groups rows with the same value?
GROUP BY
ORDER BY
SORT BY
5. How do you get the average salary from "staff"?
SELECT AVG(salary) FROM staff;
SELECT MEAN(salary) FROM staff;
SELECT AVERAGE(salary) FROM staff;
6. Which SQL operator is used for pattern matching?
LIKE
PATTERN
MATCH
7. How do you select names starting with "A"?
WHERE name LIKE 'A%'
WHERE name = 'A*'
WHERE name STARTS WITH 'A'
8. Which SQL statement removes a table from the database?
DROP TABLE table;
DELETE TABLE table;
REMOVE TABLE table;
9. How do you rename a table "old" to "new"?
ALTER TABLE old RENAME TO new;
RENAME old TO new;
CHANGE old TO new;
10. Which SQL keyword is used to add a new column?
ALTER TABLE ... ADD
INSERT COLUMN
NEW COLUMN
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