SQL Programming Beginner 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
Beginner Quiz 5
1. Which SQL statement changes the value of "salary" to 5000 for all employees?
UPDATE employees SET salary = 5000;
MODIFY employees salary = 5000;
CHANGE employees SET salary = 5000;
2. How do you select all records except those with "country" = "USA"?
WHERE country <> 'USA'
WHERE country != 'USA'
WHERE country NOT 'USA'
3. Which SQL function adds up all values in a column?
SUM()
ADD()
TOTAL()
4. How do you select the top 5 highest salaries from "staff"?
SELECT * FROM staff ORDER BY salary DESC LIMIT 5;
SELECT TOP 5 salary FROM staff;
SELECT salary FROM staff LIMIT 5 DESC;
5. How do you select all records where "name" ends with "son"?
WHERE name LIKE '%son'
WHERE name = '*son'
WHERE name ENDS WITH 'son'
6. What does the SQL statement "SELECT NOW();" return?
The current date and time
The number of rows in a table
The most recent row
7. Which SQL clause is used to join two tables?
JOIN
COMBINE
APPEND
8. How do you remove a column "phone" from table "contacts"?
ALTER TABLE contacts DROP COLUMN phone;
REMOVE COLUMN phone FROM contacts;
DELETE phone FROM contacts;
9. How do you sort results in descending order by "price"?
ORDER BY price DESC
ORDER BY price ASC
SORT BY price DOWN
10. Which keyword checks if a value exists in a list?
IN
EXISTS
CONTAINS
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