SQL Programming Intermediate 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
Intermediate Quiz 3
1. How do you select rows where "email" is not NULL?
WHERE email IS NOT NULL
WHERE email != NULL
WHERE email <> NULL
2. Which SQL statement creates a view named "active_users"?
CREATE VIEW active_users AS SELECT * FROM users WHERE active = 1;
CREATE active_users VIEW AS SELECT * FROM users WHERE active = 1;
NEW VIEW active_users AS SELECT * FROM users WHERE active = 1;
3. How do you update the salary to 6000 for employee with id=3?
UPDATE employees SET salary = 6000 WHERE id = 3;
UPDATE employees salary = 6000 WHERE id = 3;
SET salary = 6000 WHERE id = 3 IN employees;
4. Which function returns the length of a string column "name"?
LENGTH(name)
SIZE(name)
LEN(name)
5. How do you delete all rows where "status" is "inactive"?
DELETE FROM users WHERE status = 'inactive';
REMOVE FROM users WHERE status = 'inactive';
DROP FROM users WHERE status = 'inactive';
6. Which SQL statement adds a new column "age" to table "students"?
ALTER TABLE students ADD age INT;
ADD COLUMN age TO students;
ALTER students ADD age INT;
7. How do you find the maximum value in column "score"?
SELECT MAX(score) FROM table;
SELECT TOP(score) FROM table;
SELECT HIGHEST(score) FROM table;
8. Which SQL clause limits the number of rows returned?
LIMIT
ROWNUM
TOP
9. How do you select all records except those with "country" = "USA"?
WHERE country <> 'USA'
WHERE country != 'USA'
WHERE country NOT 'USA'
10. Which SQL function returns the sum of a column?
SUM()
ADD()
TOTAL()
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