Examveda

What does the AUTO_INCREMENT sequences normally begin at?

A. 0

B. 1

C. -1

D. 2

Answer: Option B

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous