The AUTO_INCREMENT column attribute is best used with which type?

Solution(By Examveda Team)

This question is about how the AUTO_INCREMENT feature in MySQL works best with different data types. Let's break it down:

AUTO_INCREMENT automatically assigns a unique, increasing number to each new row added to a table. This is super useful for creating primary keys that uniquely identify each entry.

Now, look at the options:
* FLOAT and DOUBLE are used for storing numbers with decimal points. They are not ideal for AUTO_INCREMENT because you need whole, increasing numbers.
* CHARACTER is for storing text, not numbers.
* INT is the best fit for AUTO_INCREMENT. It's a whole number data type, perfect for creating a sequence of unique IDs.

Therefore, the correct answer is Option B: INT.