Q526
What does the AUTO_INCREMENT sequences normally begin at?
A.
0
B.
1
AnswerC.
-1
D.
2
Answer: Option B
Solution
Answer: Option B
Solution:
This question is about AUTO_INCREMENT in MySQL. AUTO_INCREMENT is a feature that 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 number and increases by 1 every time you add a new row.
The question asks: What is the default starting number for this counter?
Here are the options:
* Option A: 0
* Option B: 1
* Option C: -1
* Option D: 2
The correct answer is Option B: 1.
By default, the AUTO_INCREMENT sequence starts at 1. It then automatically increments by 1 for each new row added to the table.