By default, the AUTO_INCREMENT sequences begin at . . . . . . . .
A. 0
B. 1
C. -1
D. 2
Answer: Option B
Solution (By Examveda Team)
This question is about how MySQL handles the AUTO_INCREMENT feature. AUTO_INCREMENT automatically assigns a unique number to each new row you add to a table.Think of it like a counter that starts at a specific value and increases by 1 each time. The question asks what that starting value is.
Let's look at the options:
Option A: 0 - This means the counter would start at 0, then go to 1, 2, 3, and so on.
Option B: 1 - This means the counter would start at 1, then go to 2, 3, 4, and so on.
Option C: -1 - This would start the counter at -1 and go to 0, 1, 2, and so on.
Option D: 2 - This would start the counter at 2 and go to 3, 4, 5, and so on.
The correct answer is Option B: 1. By default, MySQL's AUTO_INCREMENT starts at 1 and increments by 1 for each new row.
Join The Discussion