← All topics
Quiz: SQL Basics: questions with answers
10 questions, each with the answer and a short explanation.
Take the timed quiz + get a certificate →- Q1. Which command removes the table structure completely?
- Q2. What does UPDATE students SET city = 'Pune'; do?
- Q3. Which category does SELECT belong to?
- Q4. Which is correct SQL for text values?
- Q5. Which statement can usually be rolled back inside a transaction?
- Q6. Which category do CREATE, ALTER and DROP belong to?
- Q7. A new column is added with ALTER TABLE students ADD COLUMN email VARCHAR(80);. What value do existing rows get in it?
- Q8. You must remove all rows from a huge log table quickly but keep the table. Which command fits best?
- Q9. What does DELETE FROM students; (no WHERE) do?
- Q10. Which data type stores text of up to 50 characters, using only the space needed?