SQL Programming Intermediate Quiz 5
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
Intermediate Quiz 5
1. How do you select all records where "name" ends with "son"?
WHERE name LIKE '%son'
WHERE name = '*son'
WHERE name ENDS WITH 'son'
2. Which SQL keyword is used to remove a view?
DROP VIEW
REMOVE VIEW
DELETE VIEW
3. What is a subquery?
A query inside another query
A query that runs after the main query
A query that only returns one row
4. How do you select the second highest salary from "employees"?
SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
SELECT TOP 2 salary FROM employees;
SELECT SECOND(salary) FROM employees;
5. Which SQL statement removes duplicate rows from results?
SELECT DISTINCT ...
SELECT UNIQUE ...
SELECT REMOVE DUPLICATES ...
6. What is a FOREIGN KEY?
A key that links to a primary key in another table
A key that is always unique
A key that allows NULL values
7. 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;
8. Which SQL function returns the current time?
NOW()
CURTIME()
CURRENT_TIME
9. How do you find the number of different departments in "employees"?
SELECT COUNT(DISTINCT department) FROM employees;
SELECT COUNT(department) FROM employees;
SELECT TOTAL(department) FROM employees;
10. What does a RIGHT JOIN do?
Returns all rows from the right table and matching rows from the left
Returns only matching rows from both tables
Returns all rows from the left table
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
C# Documentation
C# Tutorials