← Quiz: SQL Basics: all 10 questions
Quiz: SQL Basics · Question 7 of 10
A new column is added with ALTER TABLE students ADD COLUMN email VARCHAR(80);. What value do existing rows get in it?
A new column is added with ALTER TABLE students ADD COLUMN email VARCHAR(80);. What value do existing rows get in it?
- A.An empty string
- B.0
- C.The value from the first row
- D.NULL
Answer & explanation
Correct answer: NULL
New columns start as NULL for rows that already exist.
Can you get the rest right without peeking?
Take the timed Quiz: SQL Basics quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →