SQL Programming Beginner Quiz 2
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 2
1. How do you insert a new row into table "users"?
INSERT INTO users VALUES (...);
ADD ROW users (...);
CREATE users (...);
2. Which SQL statement deletes all rows from a table?
DELETE FROM table;
REMOVE table;
DROP table;
3. Which SQL keyword is used to update data?
UPDATE
CHANGE
SET
4. How do you select all records from the "employees" table?
SELECT * FROM employees;
GET employees;
SHOW employees;
5. Which SQL statement is used to create a new table?
CREATE TABLE
MAKE TABLE
NEW TABLE
6. Which operator checks for equality in SQL?
=
==
EQ
7. How do you select only the "name" column from "customers"?
SELECT name FROM customers;
GET name FROM customers;
SHOW name FROM customers;
8. Which SQL function finds the largest value?
MAX()
BIGGEST()
TOP()
9. How do you count the number of different cities in "clients"?
SELECT COUNT(DISTINCT city) FROM clients;
SELECT COUNT(city) FROM clients;
SELECT TOTAL(city) FROM clients;
10. Which SQL statement changes a value in a table?
UPDATE table SET ... WHERE ...;
MODIFY table ...;
CHANGE 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
SQL Documentation
SQL Tutorials