Examveda

Which column attribute provides unique numbers for identification?

A. AUTO_INCREMENT

B. UNSIGNED

C. IDENTIFY

D. DESCRIBE

Answer: Option A

Solution (By Examveda Team)

This question is about special features in MySQL that help us manage data in our tables. We want to find the one that gives each row a unique number for easy identification.
Let's look at the options:
Option A: AUTO_INCREMENT
This is the correct answer! AUTO_INCREMENT automatically assigns a unique number to each new row you add to a table. It's like having a built-in counter that makes sure every row has a distinct ID.
Option B: UNSIGNED
This option is used for numbers, making sure they are positive. It doesn't create unique identifiers.
Option C: IDENTIFY
This is not a valid MySQL attribute.
Option D: DESCRIBE
This is a command to show the structure of a table, not an attribute for creating unique IDs.
Therefore, the answer is Option A: AUTO_INCREMENT.
Let me know if you have any other questions!

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous