← Quiz: Keys and Constraints: all 10 questions
Quiz: Keys and Constraints · Question 10 of 10
An INSERT gives no value for a column declared city VARCHAR(30) DEFAULT 'Jaipur'. What is stored?
An INSERT gives no value for a column declared city VARCHAR(30) DEFAULT 'Jaipur'. What is stored?
- A.NULL
- B.An error is raised
- C.An empty string
- D.'Jaipur'
Answer & explanation
Correct answer: 'Jaipur'
DEFAULT fills the value when none is given.
Can you get the rest right without peeking?
Take the timed Quiz: Keys and Constraints quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →