Vidyalelo
MySQL · Q349

MySQL

Programming · MySQL · question 349

Q349

Which column attribute provides unique numbers for identification?

A.
AUTO_INCREMENT
Answer
B.
UNSIGNED
C.
IDENTIFY
D.
DESCRIBE

Answer: Option A

Solution

Answer: Option A
Solution:
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!