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!
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network

Join The Discussion