🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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 →
  1. Q1. Which command removes the table structure completely?
  2. Q2. What does UPDATE students SET city = 'Pune'; do?
  3. Q3. Which category does SELECT belong to?
  4. Q4. Which is correct SQL for text values?
  5. Q5. Which statement can usually be rolled back inside a transaction?
  6. Q6. Which category do CREATE, ALTER and DROP belong to?
  7. Q7. A new column is added with ALTER TABLE students ADD COLUMN email VARCHAR(80);. What value do existing rows get in it?
  8. Q8. You must remove all rows from a huge log table quickly but keep the table. Which command fits best?
  9. Q9. What does DELETE FROM students; (no WHERE) do?
  10. Q10. Which data type stores text of up to 50 characters, using only the space needed?