ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

The column attribute provides unique numbers for identification is . . . . . . . .

Answer & Solution
Correct Answer: Option A
This question asks about a column attribute in MySQL that helps assign unique numbers for identification. Let's break down the options:
Option A: AUTO_INCREMENT: This is the correct answer! AUTO_INCREMENT automatically generates a unique number for each new row added to the table. It starts with a specific value and increases by one for each new entry.
Option B: UNSIGNED: This attribute specifies that a column can only hold positive numbers (no negative values). While it helps with data consistency, it doesn't directly provide unique identification numbers.
Option C: IDENTIFY: MySQL doesn't have an attribute called "IDENTIFY."
Option D: DESCRIBE: DESCRIBE is a command used to get information about a table's structure, not a column attribute itself.
Therefore, the answer is Option A: AUTO_INCREMENT. It's the attribute responsible for generating unique numbers for identification in MySQL tables.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.