Which feature is used for the automatic increment of the column?
A. AUTO_INCREMENT
B. AUTO
C. INCREMENT
D. All of the mentioned
Answer: Option A
Solution (By Examveda Team)
This question is about how to make a column in your MySQL database automatically increase its value every time you add a new row.Imagine you have a table for storing customer information. Each customer needs a unique ID number. You could manually assign these ID numbers, but it's much easier to have the database do it for you.
That's where AUTO_INCREMENT comes in! This feature tells MySQL to automatically generate the next available number for a column whenever a new row is added.
So the answer is Option A: AUTO_INCREMENT
The other options are incorrect because:
- AUTO is not a feature in MySQL.
- INCREMENT is a part of the AUTO_INCREMENT feature, but not a separate feature itself.
Join The Discussion