SQL Programming Intermediate 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
Intermediate Quiz 2
1. How do you rename a column "old" to "new"?
ALTER TABLE t RENAME COLUMN old TO new;
RENAME COLUMN old TO new;
CHANGE COLUMN old TO new;
2. What does the UNIQUE constraint do?
Ensures all values in a column are different
Allows only non-null values
Creates a foreign key
3. Which function returns the current date in SQL?
CURRENT_DATE
NOW()
GETDATE()
4. How do you remove all rows from a table but keep its structure?
TRUNCATE TABLE table;
DROP TABLE table;
DELETE TABLE table;
5. Which SQL statement creates an index?
CREATE INDEX idx ON t(col);
ADD INDEX idx TO t(col);
INDEX idx ON t(col);
6. How do you select employees whose name starts with "A"?
SELECT * FROM employees WHERE name LIKE 'A%';
SELECT * FROM employees WHERE name = 'A*';
SELECT * FROM employees WHERE name STARTS WITH 'A';
7. What does a LEFT JOIN do?
Returns all rows from the left table and matching rows from the right
Returns only matching rows from both tables
Returns all rows from the right table
8. How do you get the total number of rows in a table "orders"?
SELECT COUNT(*) FROM orders;
SELECT TOTAL(*) FROM orders;
SELECT SUM(*) FROM orders;
9. Which SQL clause sorts the result set?
ORDER BY
SORT BY
GROUP BY
10. How do you select all rows where column "score" is between 80 and 100?
WHERE score BETWEEN 80 AND 100
WHERE score >= 80 AND score <= 100
WHERE score IN (80, 100)
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